..follow me on https://www.twitter.com/linuxonlinehelp

WordPress: Change Word on all content sites with mysql

If you run a WordPress Blog or other CMS with MySQL Backend you can easy change one same word or expression on all content sites on the fly

  • Do a mysqldump at first of the current database

$ mysqldump -u username -p dbname > dbbackup.sql

  • Login to the MySQL server Console
  • Switch to the Database

mysql> use dbname;

  • run command for tests, lists touched posts

mysql> SELECT * FROM wp_posts WHERE (post_content LIKE '%expression%');

  • Run Replace code to pre, cause i use preformat text plugin for the copy & paste boxes

mysql> UPDATE wp_posts SET post_content = REPLACE ( post_content, 'code', 'pre');

  • exit
  • test results..