Return to Snippet

Revision: 24301
at February 25, 2010 12:50 by Jamie


Initial Code
UPDATE files SET filepath = REPLACE(filepath,'path/to/search','path/to/replace');

Initial URL

                                

Initial Description
This is useful for when a Wordpress environment goes live; typically the uploads have an absolute URL.

Initial Title
MySQL Find and Replace

Initial Tags
mysql, path, replace, find

Initial Language
MySQL