Posted By

suibhne on 10/27/10


mysql wordpress

Versions (?)

Update File Upload Domain in Wordpress Posts

 / Published in: SQL

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.

  1. UPDATE wp_posts SET post_content = REPLACE(post_content, '', '')

Report this snippet  

You need to login to post a comment.