Moving WordPress: update URLs in database
Posted in: Code snippets, WordPressUPDATE wp_posts set post_content=REPLACE(post_content, 'http://new.domain.com/', 'http://www.domain.com/')
UPDATE wp_posts set post_content=REPLACE(post_content, 'http://new.domain.com/', 'http://www.domain.com/')