Skip to content

Instantly share code, notes, and snippets.

@adanzilla
Created August 6, 2015 17:12
Show Gist options
  • Save adanzilla/005e48f96f6093a959f4 to your computer and use it in GitHub Desktop.
Save adanzilla/005e48f96f6093a959f4 to your computer and use it in GitHub Desktop.
SQL - Actualiza la tabla wp_posts al migrar tu Wordpress
UPDATE wp_posts
SET
post_content = REPLACE (post_content, 'http://localhost/tusitio.com.mx', 'http://www.tusitio.com.mx')
WHERE post_content LIKE '%http://localhost/tusitio.com.mx%';
UPDATE wp_posts
SET
guid = REPLACE (guid, 'http://localhost/tusitio.com.mx', 'http://www.tusitio.com.mx')
WHERE guid LIKE '%http://localhost/tusitio.com.mx%';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment