Skip to content

Instantly share code, notes, and snippets.

@ashhitch

ashhitch/update-urls.sql

Last active July 31, 2025 09:21
Show Gist options
  • Save ashhitch/8435268 to your computer and use it in GitHub Desktop.
Save ashhitch/8435268 to your computer and use it in GitHub Desktop.
Download ZIP
Update your site URL in Wordpress to a new one. If you have changed your table prefix from wp_ the update the code below first.
Raw
update-urls.sql
/* update all post permalinks */
update wp_posts
set guid = REPLACE(guid, 'http://www.oldsite.com', 'http://www.newsite.com')
where guid LIKE '%http://www.oldsite.com%';
/* update all post content */
update wp_posts
SET post_content = REPLACE(post_content, 'http://www.oldsite.com', 'http://www.newsite.com')
where post_content LIKE '%http://www.oldsite.com%';
/* update all post meta */
update wp_postmeta
SET meta_value = REPLACE(meta_value, 'http://www.oldsite.com', 'http://www.newsite.com')
where meta_value LIKE '%http://www.oldsite.com%';
/* update all options */
update wp_options
set option_value = REPLACE(option_value, 'http://www.oldsite.com', 'http://www.newsite.com')
where option_value LIKE '%http://www.oldsite.com%';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment