I find myself using WordPress more and more for client websites. Since 90% of the time, I develop on a dev domain, it means that the links inserted by WordPress point to the dev domain which presents an issue when it’s time to hold your breath and take the new site live on the clients domain. So anyway, a useful query to update the old domain to the new domain in all of the sites’s posts is as follows: