SQL query to update wp_options records that are specific to the host of a WordPress site. Run this query after copying the DB to another server (if this URL is different). Useful for deploying WordPress from a dev server to a live environment.
This is useful for when a WordPress environment goes live; typically the uploads have an absolute URL. UPDATE files SET filepath = REPLACE(filepath,’path/to/search’,’path/to/replace’);