UPDATE wp_posts SET post_content = REPLACE(post_content, "olddomain.com", "newdomain.com") WHERE post_content LIKE '%olddomain.com%';

REPLACE(haystack, needle, replacement needle);