MySQL “replace” is your friend

Verfasst von system am 30. September 2010 - 15:03

Ever had to change the filepath in the files-table after some path restructures? MySQL “replace” is your friend:

update files set filepath = replace(filepath, 'sites/oldpath/files/','sites/newpath/files/');