Updating the URL in post content

When moving the content from an old WordPress site you need to update the URLs of any links to uploaded media. It’s easy to miss this step, but it’s also an easy fix.

Make sure you run the following SQL Query:

UPDATE wp_posts SET post_content = replace(post_content, 'www.old-url.wip', 'new-url.wip');