-- Check siteurl SELECT option_value FROM wp_options WHERE option_name = 'siteurl' -- Update URL_move_from and URL_move_to inside single quotes UPDATE wp_options SET option_value = replace( option_value, 'URL_move_from', 'URL_move_to' ) WHERE option_name = 'home' OR option_name = 'siteurl'; UPDATE wp_posts SET guid = replace(guid, 'URL_move_from','URL_move_to'); UPDATE wp_posts SET post_content = replace(post_content, 'URL_move_from','URL_move_to');

Update db prefix, this example is for default “wp_”