Skip to content

Instantly share code, notes, and snippets.

@nielsenrc

nielsenrc/mysql-find-replace-wordpress-db.sql

Created April 28, 2016 16:06
Show Gist options
  • Save nielsenrc/6cdbf05ab8ff14163681e98f3044f363 to your computer and use it in GitHub Desktop.
Save nielsenrc/6cdbf05ab8ff14163681e98f3044f363 to your computer and use it in GitHub Desktop.
Download ZIP
MySQL | MySql Query to Sweep Wordpress Database for String
Raw
mysql-find-replace-wordpress-db.sql
UPDATE wp_posts SET post_content = REPLACE(post_content,'find','replace');
UPDATE wp_posts SET guid = REPLACE(guid,'find','replace');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment