Skip to content

Instantly share code, notes, and snippets.

@pauiglesias

pauiglesias/wordpress-sql-replace-urls

Created July 29, 2016 17:44
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save pauiglesias/408fd2cd07bbdc42e6ac3d7c48d8650d to your computer and use it in GitHub Desktop.
Save pauiglesias/408fd2cd07bbdc42e6ac3d7c48d8650d to your computer and use it in GitHub Desktop.
Download ZIP
Raw
wordpress-sql-replace-urls
UPDATE wp_posts SET post_content = REPLACE(post_content, "http://base-dev-url/", "http://base-prod-url/") WHERE post_content LIKE "%http://base-dev-url/%"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment