WordPress MySQL Find / Replace When Moving Domains

WordPress MySQL Find / Replace When Moving Domains

Great piece of code to use when moving a WordPress site from one domain to another; quick way to replace the old domain name in the DB with the new one. UPDATE wp_options SET option_value = replace(option_value, ‘http://olddomain.com’,...