Skip to content

Instantly share code, notes, and snippets.

@joelataylor

joelataylor/change-wp-urls.sql

Created December 29, 2014 14:24
Show Gist options
  • Save joelataylor/aec1d1bd6a3bc5520a60 to your computer and use it in GitHub Desktop.
Save joelataylor/aec1d1bd6a3bc5520a60 to your computer and use it in GitHub Desktop.
Download ZIP
Change WP URLs
Raw
change-wp-urls.sql
#Fix WP URLs
SET @oldurl = 'http://staging.windfarmstudios.net';
SET @newurl = 'http://staging.wubdfarnstyduis.com';
UPDATE wm_wp_options SET option_value = REPLACE(option_value, @oldurl, @newurl);
UPDATE wm_wp_posts SET guid = REPLACE (guid, @oldurl, @newurl);
UPDATE wm_wp_posts SET post_content = REPLACE (post_content, @oldurl, @newurl);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment