WP-Database-Domain-Find-Replace.sql

/* !!!!!! 
ALWAYS CREATE A BACKUP BEFORE RUNNING THESE COMMANDS! 
!!!!!! */

UPDATE wp_options
SET option_value = replace(option_value, 'https://old-domain.com', 'https://new-domain.com')
WHERE option_name = 'home' OR option_name = 'siteurl';

UPDATE wp_posts
SET guid = replace(guid, 'https://old-domain.com', 'https://new-domain.com');

UPDATE wp_posts
SET post_content = replace(post_content, 'https://old-domain.com', 'https://new-domain.com');

UPDATE wp_postmeta
SET meta_value = replace(meta_value,'https://old-domain.com','https://new-domain.com');

A few notes:

• WordPress advises against changing the GUID value, mostly because feed readers might mark content as unread. This isn't a huge issue if the site your working on doesn't utilize feeds prominently.
• In certain situations, serialized data can become corrupt. Always backup the target DB before running these commands!
• This script assumes the default wp_ table prefixes