I have just moved hosts, and with the move I've also changed the setup that I have for media uploads.
I used to host my media on a subdomain called media.detailsofmylife.net, but now that I have switched over, I want to go back to the traditional detailsofmylife.net/wp-content/uploads/ style. I have already backed up and relocated the content so it should be ready to go.
For example, yesterday, an image used to located here:
but now it is located here:
Could someone please help me with the necessary SQL statement to correct all of the old url references to the new format?