Skip to content

Instantly share code, notes, and snippets.

@icandeveloper

icandeveloper/gist:c6c54761ab92f5fa68226057d3c20dda

Last active May 10, 2016 08:55
Show Gist options
  • Save icandeveloper/c6c54761ab92f5fa68226057d3c20dda to your computer and use it in GitHub Desktop.
Save icandeveloper/c6c54761ab92f5fa68226057d3c20dda to your computer and use it in GitHub Desktop.
Download ZIP
Wordpress | Find/Replace database
Raw
gistfile1.txt
UPDATE `wp_postmeta` SET `meta_value` = replace(`meta_value`,'[FIND]','[REPLACE]');
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