Skip to content

Instantly share code, notes, and snippets.

@oneluiz

oneluiz/url.sql

Created August 23, 2018 15:31
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save oneluiz/f934154ec864d2972b5992d4fe59e5e3 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save oneluiz/f934154ec864d2972b5992d4fe59e5e3 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. oneluiz created this gist Aug 23, 2018.
    5 changes: 5 additions & 0 deletions url.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,5 @@
    UPDATE `wp_posts` SET guid = REPLACE(guid, 'http://www.URL-VIEJA.com','http://www.URL-NUEVA.com');

    UPDATE `wp_posts` SET post_content = REPLACE(post_content, 'http://www.URL-VIEJA.com','http://www.URL-NUEVA.com');

    UPDATE `wp_options` SET option_value = REPLACE(option_value, 'http://www.URL-VIEJA.com','http://www.URL-NUEVA.com') WHERE option_name = 'home' OR option_name = 'siteurl';