WordPress SQL update

WPUpdate.sql

#set variables
SET @oldurl = 'http://oldurl.com';
SET @newurl = 'http://newurl.com';

#update wp_site options
UPDATE wp_options SET option_value = replace(option_value, @oldurl, @newurl) WHERE option_name = 'home' OR option_name = 'siteurl';

#update wp_posts guid
UPDATE wp_posts SET guid = REPLACE (guid, @oldurl, @newurl);

#update wp_posts content
UPDATE wp_posts SET post_content = REPLACE (post_content, @oldurl, @newurl);

#update wp_postmeta
UPDATE wp_postmeta SET meta_value = REPLACE (meta_value, @oldurl, @newurl);