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

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');

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