update wp_posts set post_content = replace(post_content, 'http://www.TESTDOMAIN.com', 'http://www.LIVEDOMAIN.com')

This is a simple SQL statement which will update all the posts within a Wordpress installation changing the domain which files were uploaded to. 

Very handy if migrating a site from a test to live environment and all embedded images are referenced using the test url.

Update File Upload Domain in Wordpress Posts

mysql, wordpress

SQL