Quick snippet to change all instances of WordPress URL

Sometimes you are moving a websites folder structure, or sometimes you are moving a website hosts. This quick and easy sql script will allow you to update all instances of the current URL with a new URL so moving wordpress sites is painless.   UPDATE wp_options SET option_value = replace(option_value, ‘http://www.oldurl’, ‘http://www.newurl’) WHERE option_name = […]