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..