Move WordPress to a new URL.
Paste your old and new domains. We’ll generate the SQL — you run it against your database.
SQL output
1UPDATE wp_posts SET post_content = replace(post_content, 'https://www.old-domain.com/', 'https://www.new-domain.com/');2UPDATE wp_posts SET guid = replace(guid, 'https://www.old-domain.com/', 'https://www.new-domain.com/');3UPDATE wp_postmeta SET meta_value = replace(meta_value, 'https://www.old-domain.com/', 'https://www.new-domain.com/');4UPDATE wp_options SET option_value = 'https://www.new-domain.com/' WHERE option_name = 'siteurl';5UPDATE wp_options SET option_value = 'https://www.new-domain.com/' WHERE option_name = 'home';
Back up your database before running. There’s no undo.