WordPress SQL Query To Change SiteURL And HomeURL

Hi Friends, Some days ago I was transferring one blog from one domain to its new domain, So first  I transfered all things to new domain and then change wp-config.php file variables. Now I need to change siteurl and home URL of site, So to change it we need to open phpmyadmin and then use one query to change it, we can do this by edit siteurl and home url row of wp_options table but below is the query by which you can easily change siteurl and homeurl 

[sql]UPDATE wp_options SET option_value = replace(option_value, 'http://www.oldsiteurl.com', 'http://www.newsiteurl.com') WHERE option_name = 'home' OR option_name = 'siteurl';[/sql]

So by above query you can change siteurl and homeurl to your new domain. Just replace your values in this query ‘http://www.oldsiteurl.com’ instead of this put your old site url and ‘http://www. newsiteurl.com’  instead of this your new domain value.

So by this wordpress query we can change site url and home url in wordpress. Let me know if you have any questions.