SQL+Wordpress: Changing WP Site Url

wp-change-site-url.sql

SET NAMES 'utf8mb4';
SET CHARACTER SET 'utf8mb4';

SET @origin_url = 'http://localhost/origem';
SET @destiny_url = 'http://localhost/destino';

UPDATE wp_options
SET option_value = REPLACE(option_value, @origin_url, @destiny_url)
WHERE option_value LIKE (CONCAT('%',@origin_url,'%'));


UPDATE wp_posts
SET
post_content = REPLACE(post_content, @origin_url, @destiny_url),
post_excerpt = REPLACE(post_excerpt, @origin_url, @destiny_url),
guid = REPLACE(guid, @origin_url, @destiny_url)
WHERE
    post_content LIKE (CONCAT('%',@origin_url,'%'))
    OR
    post_excerpt LIKE (CONCAT('%',@origin_url,'%'))
    OR
    guid LIKE (CONCAT('%',@origin_url,'%'));


UPDATE wp_postmeta
SET meta_value = REPLACE(meta_value, @origin_url, @destiny_url)
WHERE meta_value LIKE (CONCAT('%',@origin_url,'%'));

UPDATE wp_termmeta
SET meta_value = REPLACE(meta_value, @origin_url, @destiny_url)
WHERE meta_value LIKE (CONCAT('%',@origin_url,'%'));

#UPDATE wp_taxonomymeta
#SET meta_value = REPLACE(meta_value, @origin_url, @destiny_url)
#WHERE meta_value LIKE (CONCAT('%',@origin_url,'%'));

#