change-url-via-db #sql

change-url-via-db

UPDATE wp_options 
SET option_value = replace(option_value, 'https://domain.com', 'https://domain.local') 
WHERE option_name = 'home' OR option_name = 'siteurl';

UPDATE wp_posts 
SET guid = replace(guid, 'https://domain.com', 'https://domain.local');

UPDATE wp_posts 
SET post_content = replace(post_content, 'https://domain.com', 'https://domain.local');

UPDATE wp_postmeta 
SET meta_value = replace(meta_value, 'https://domain.com', 'https://domain.local');


wp db query "UPDATE wp_options SET option_value = replace(option_value, 'https://domain.com', 'https://domain.local') WHERE option_name = 'home' OR option_name = 'siteurl';"
wp db query "UPDATE wp_posts SET guid = replace(guid, 'https://domain.com', 'https://domain.local');"
wp db query "UPDATE wp_posts SET post_content = replace(post_content, 'https://domain.com', 'https://domain.local');"
wp db query "UPDATE wp_postmeta SET meta_value = replace(meta_value, 'https://domain.com', 'https://domain.local');"