How to change the Site URL and Home URL on a WordPress Site

When do you need to change the site URL and home URL in wordpress

1. When you move your site from your PC to online or simply when you move your project from one location to another.

Solution:

Simply , Add the following lines in wp-config.php to update site URL and Home URL as

1. wp-config.php

define('siteurl','http://example.com');
define('home','http://example.com');

OR
2.Add the following lines in functions.php

update_option('siteurl','http://example.com');
update_option('home','http://example.com');

OR
3. Use the following sql query to update the site url and home url as

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