You can use the replace string function:
update table set file_path=replace(file_path,'aFolder','aFolder/aChildFolder');
In each update aFolder will be replaced by the new path.
John Mistler wrote:
I have a column that holds hard disk file location info such as: "/Volumes/External HD/aFolder/aFile.pdf" "/Volumes/External HD/aFolder/anotherFile.pdf" etc. . . (many files located in the same folder)
Can anyone suggest a single statement (or multiple) that would update every file location located in this same folder to another location, say:
"/Volumes/External HD/aFolder/aChildFolder/aFile.pdf" "/Volumes/External HD/aFolder/aChildFolder/anotherFile.pdf" etc . . . ?
Thanks,
John
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
