Skip to content

Instantly share code, notes, and snippets.

@ben-barbier
Last active January 18, 2017 08:20
Show Gist options
  • Save ben-barbier/69c35380af8475da0a9c617f73ba0694 to your computer and use it in GitHub Desktop.
Save ben-barbier/69c35380af8475da0a9c617f73ba0694 to your computer and use it in GitHub Desktop.
UPDATE wp_options SET option_value = REPLACE(option_value, 'http://monsite.preprod.fr', 'http://www.prod.fr') WHERE option_value LIKE '%http://monsite.preprod.fr%';
UPDATE wp_posts SET post_content = REPLACE(post_content, 'http://monsite.preprod.fr', 'http://www.prod.fr') WHERE post_content LIKE '%http://monsite.preprod.fr%';
UPDATE wp_posts SET guid = REPLACE(guid, 'http://monsite.preprod.fr', 'http://www.prod.fr') WHERE guid LIKE '%http://monsite.preprod.fr%';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment