Wordpress Search and Replace

gistfile1.txt

// NOTE: All URLs must contain their protocol and must NOT have trailing slashes

// Set the path for all JS / CSS / template imports
update wp_options set option_value = 'new_domain' where option_id in (1, 2)

// Update all links
UPDATE wp_posts SET guid = replace(guid, 'old_url','new_url');

// Replace URL references in post content
UPDATE wp_posts SET post_content = replace(post_content, 'old_url', 'new_url');