Skip to content

Instantly share code, notes, and snippets.

@groupewibi
Created August 30, 2022 14:23
Show Gist options
  • Save groupewibi/1ca20dc2ef5ad378bf009cd92c034ba3 to your computer and use it in GitHub Desktop.
Save groupewibi/1ca20dc2ef5ad378bf009cd92c034ba3 to your computer and use it in GitHub Desktop.
Wordpress - Change Urls in Database
UPDATE wp_options SET option_value = replace(option_value, '[previous-url]', '[next-url]') WHERE option_name = 'home' OR option_name = 'siteurl';
UPDATE wp_posts SET post_content = replace(post_content, '[previous-url]', '[next-url]');
UPDATE wp_postmeta SET meta_value = replace(meta_value,'[previous-url]','[next-url]');
UPDATE wp_usermeta SET meta_value = replace(meta_value, '[previous-url]','[next-url]');
UPDATE wp_links SET link_url = replace(link_url, '[previous-url]L','[next-url]');
UPDATE wp_comments SET comment_content = replace(comment_content , '[previous-url]','[next-url]');
/* For images in a single post */
UPDATE wp_posts SET post_content = replace(post_content, '[previous-url]', '[next-url]');
/* For attached images in a post: */
UPDATE wp_posts SET guid = replace(guid, '[previous-url]','[next-url]');
/* For images with old link manager: */
UPDATE wp_links SET link_image = replace(link_image, '[previous-url]','[next-url]');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment