Change Wordpress FQDN via sql

UPDATE wp_options 
  SET option_value = replace(option_value, 'http://oldurl.com', 'http://newurl.com') 
  WHERE option_name = 'home' OR option_name = 'siteurl';
  
UPDATE wp_posts 
  SET guid = replace(guid, 'http://oldurl.com', 'http://newurl.com');

UPDATE wp_posts 
  SET post_content = replace(post_content, 'http://oldurl.com', 'http://newurl.com'); 

UPDATE wp_postmeta 
  SET meta_value = replace(meta_value,'http://oldurl.com', 'http://newurl.com');

Do you have any question to us?

Contact us and we'll get back to you as soon as possible.