Skip to content

Instantly share code, notes, and snippets.

@rafaelkendrik

rafaelkendrik/url-update.sql

Created April 24, 2019 18:31
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 rafaelkendrik/511386959930fc5e79374028145f6861 to your computer and use it in GitHub Desktop.
Save rafaelkendrik/511386959930fc5e79374028145f6861 to your computer and use it in GitHub Desktop.
Download ZIP
wordpress-url-update
Raw
url-update.sql
UPDATE wp_options \
SET option_value=replace(option_value, 'url_curr', 'url_new') \
WHERE option_name='home' OR option_name='siteurl';
UPDATE wp_posts \
SET guid=replace(guid, 'url_curr','url_new');
UPDATE wp_posts \
SET post_content=replace(post_content, 'url_curr', 'url_new');
UPDATE wp_postmeta SET meta_value=replace(meta_value,'http://noparana.com.br/','http://localhost:4000');
@rafaelkendrik
Copy link
Author

Url update query generator: http://hullen.github.io/wpsqlupdate

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment