Store img tags in database and retrieve it

If ever you've developed with WordPress, this will be a familiar issue. All <img> tags will contain the site's base URL, and it's stored in a couple of other places too.

Rather than hack around with the WYSIWYG content editor, when we migrate a site from development to production we simply run a few queries like:

UPDATE table SET field = REPLACE(field, "http://oldurl", "http://newurl");