批量修改博客的内容标题和tags

作者：时鹏亮 | 更新时间：06/02/2015 06:37:50
请知悉：本文最近一次更新为 9年 前，文中内容可能已经过时。

之前一些单词拼写有错误，没有注意大小写之类的细节，索性抽点时间批量改了下，总结代码如下：

UPDATE wp_posts SET post_content = replace(post_content, 'jquery','jQuery');
UPDATE wp_posts SET post_title = replace(post_title, 'jquery','jQuery');
UPDATE wp_posts SET post_content = replace(post_content, 'iis','IIS');
UPDATE wp_posts SET post_title = replace(post_title, 'iis','IIS');
UPDATE wp_posts SET post_content = replace(post_content, 'ios','iOS');
UPDATE wp_posts SET post_title = replace(post_title, 'ios','iOS');
UPDATE wp_posts SET post_content = replace(post_content, 'IOS','iOS');
UPDATE wp_posts SET post_title = replace(post_title, 'IOS','iOS');
UPDATE wp_posts SET post_content = replace(post_content, 'wordpress','WordPress');
UPDATE wp_posts SET post_title = replace(post_title, 'wordpress','WordPress');
UPDATE wp_posts SET post_content = replace(post_content, 'mysql','MySQL');
UPDATE wp_posts SET post_title = replace(post_title, 'mysql','MySQL');
UPDATE wp_posts SET post_content = replace(post_content, 'sqlite','SQLite');
UPDATE wp_posts SET post_title = replace(post_title, 'sqlite','SQLite');
UPDATE wp_posts SET post_content = replace(post_content, 'discuz','Discuz!');
UPDATE wp_posts SET post_title = replace(post_title, 'discuz','Discuz!');
UPDATE wp_posts SET post_content = replace(post_content, 'access','Access');
UPDATE wp_posts SET post_title = replace(post_title, 'access','Access');
UPDATE wp_posts SET post_content = replace(post_content, 'android','Android');
UPDATE wp_posts SET post_title = replace(post_title, 'android','Android');
UPDATE wp_posts SET post_content = replace(post_content, 'apache','Apache');
UPDATE wp_posts SET post_title = replace(post_title, 'apache','Apache');
UPDATE wp_posts SET post_content = replace(post_content, 'chrome','Chrome');
UPDATE wp_posts SET post_title = replace(post_title, 'chrome','Chrome');
UPDATE wp_posts SET post_content = replace(post_content, 'excel','Excel');
UPDATE wp_posts SET post_title = replace(post_title, 'excel','Excel');
UPDATE wp_posts SET post_content = replace(post_content, 'firefox','Firefox');
UPDATE wp_posts SET post_title = replace(post_title, 'firefox','Firefox');
UPDATE wp_posts SET post_content = replace(post_content, 'flash','Flash');
UPDATE wp_posts SET post_title = replace(post_title, 'flash','Flash');
UPDATE wor34439_terms SET name = replace(name, 'nginx','Nginx');
UPDATE wp_posts SET post_content = replace(post_content, 'nginx','Nginx');
UPDATE wp_posts SET post_title = replace(post_title, 'nginx','Nginx');
UPDATE wor34439_terms SET name = replace(name, 'photoshop','Photoshop');
UPDATE wp_posts SET post_content = replace(post_content, 'photoshop','Photoshop');
UPDATE wp_posts SET post_title = replace(post_title, 'photoshop','Photoshop');
UPDATE wor34439_terms SET name = replace(name, 'seo','SEO');
UPDATE wp_posts SET post_content = replace(post_content, 'seo','SEO');
UPDATE wp_posts SET post_title = replace(post_title, 'seo','SEO');
UPDATE wor34439_terms SET name = replace(name, 'shadowsocks','Shadowsocks');
UPDATE wp_posts SET post_content = replace(post_content, 'shadowsocks','Shadowsocks');
UPDATE wp_posts SET post_title = replace(post_title, 'shadowsocks','Shadowsocks');
UPDATE wor34439_terms SET name = replace(name, 'shell','Shell');
UPDATE wp_posts SET post_content = replace(post_content, 'shell','Shell');
UPDATE wp_posts SET post_title = replace(post_title, 'shell','Shell');
UPDATE wor34439_terms SET name = replace(name, 'sublime','Sublime');
UPDATE wp_posts SET post_content = replace(post_content, 'sublime','Sublime');
UPDATE wp_posts SET post_title = replace(post_title, 'sublime','Sublime');
UPDATE wor34439_terms SET name = replace(name, 'seajs','SeaJS');
UPDATE wp_posts SET post_content = replace(post_content, 'seajs','SeaJS');
UPDATE wp_posts SET post_title = replace(post_title, 'seajs','SeaJS');
UPDATE wor34439_terms SET name = replace(name, 'virtual box','VirtualBox');
UPDATE wp_posts SET post_content = replace(post_content, 'virtual box','VirtualBox');
UPDATE wp_posts SET post_title = replace(post_title, 'virtual box','VirtualBox');
UPDATE wor34439_terms SET name = replace(name, 'vmware','VMware');
UPDATE wp_posts SET post_content = replace(post_content, 'vmware','VMware');
UPDATE wp_posts SET post_title = replace(post_title, 'vmware','VMware');
UPDATE wor34439_terms SET name = replace(name, 'zend','Zend');
UPDATE wp_posts SET post_content = replace(post_content, 'zend','Zend');
UPDATE wp_posts SET post_title = replace(post_title, 'zend','Zend');
UPDATE wor34439_terms SET name = replace(name, 'php','PHP');
UPDATE wp_posts SET post_title = replace(post_title, 'php','PHP');
UPDATE wor34439_terms SET name = replace(name, 'centos','CentOS');
UPDATE wp_posts SET post_content = replace(post_content, 'centos','CentOS');
UPDATE wp_posts SET post_title = replace(post_title, 'centos','CentOS');
UPDATE wor34439_terms SET name = replace(name, 'javascript','JavaScript');
UPDATE wp_posts SET post_content = replace(post_content, 'javascript','JavaScript');
UPDATE wp_posts SET post_title = replace(post_title, 'javascript','JavaScript');
UPDATE wor34439_terms SET name = replace(name, 'greasemonkey','Greasemonkey');
UPDATE wp_posts SET post_content = replace(post_content, 'greasemonkey','Greasemonkey');
UPDATE wp_posts SET post_title = replace(post_title, 'greasemonkey','Greasemonkey');
UPDATE wor34439_terms SET name = replace(name, 'PHPmyadmin','phpMyAdmin');
UPDATE wp_posts SET post_content = replace(post_content, 'phpmyadmin','phpMyAdmin');
UPDATE wp_posts SET post_title = replace(post_title, 'phpmyadmin','phpMyAdmin');
UPDATE wp_posts SET post_content = replace(post_content, 'PHPmyadmin','phpMyAdmin');
UPDATE wp_posts SET post_title = replace(post_title, 'PHPmyadmin','phpMyAdmin');
如您从本文得到了有价值的信息或帮助，请考虑扫描文末二维码捐赠和鼓励。

如本文对您有用，捐赠和留言 将是对我最好的支持~（捐赠可转为站内积分）
如愿意，请向朋友推荐本站，谢谢。

尊重他人劳动成果。转载请务必附上原文链接，我将感激不尽。

与《批量修改博客的内容标题和tags》相关的博文：

留言

avatar
😀
😀😁😂😅😭🤭😋😘🤔😰😱🤪💪👍👎🤝🌹👌