I hope you all are enjoying my previous post https://raghunathgurjar.wordpress.com/2013/12/24/how-change-and-update-wordpress-urls-in-database-when-site-is-moved-to-new-host/ that i had posted it few year ago.
During setup of wordpress site from “Local Server” to “Live Server”, we always need to update the site & home url of the website as per new domain url. There are three way for update to the site url after move site on other server.
1.) You can directly run given below mysql query from phpmyadmin
Click here to read more