Change url in wordpress when migrating a site

ms-wp-changing-url.sql

SET @old := 'http://oldsite.carol.local';
SET @chunk_old := '%oldsite.carol%';
SET @new := 'http://mynewsite.carol.local';

UPDATE wp_options SET option_value = replace(option_value, @old, @new);
UPDATE wp_posts SET guid = replace(guid, @old, @new);
UPDATE wp_posts SET post_content = replace(post_content, @old, @new);
UPDATE wp_postmeta SET meta_value = replace(meta_value,@old, @new);

/* It is always good to check if there is any other portings of url pointing to the old site */
select option_value from wp_options where option_value like  @chunk_old;
select guid from wp_posts where guid like @chunk_old;
select post_content from wp_posts where post_content like @chunk_old;
select meta_value from wp_postmeta where meta_value like @chunk_old;