How to change all URL’s of WordPress site using MYSQL

Using the following code you can change the URL of your WordPress site with the help of MYSQL command. You need to run this MYSQL query in your PHPMYADMIN or any other MYSQL manager. Please make sure you changed the old url and new url values as per your site urls.

UPDATE wp_options SET option_value = replace(option_value, 'http://old.com', 'http://new.com') WHERE option_name = 'home' OR option_name = 'siteurl';
UPDATE wp_posts SET guid = replace(guid, 'http://old.com','http://new.com'); 
UPDATE wp_posts SET post_content = replace(post_content, 'http://old.com', 'http://new.com'); 
UPDATE wp_postmeta SET meta_value = replace(meta_value,'http://old.com','http://new.com');