Wow! That works. Thanks a bunch! While we're at it, I have one more hang-up:
Is there a (DISTINCT?) statement that will select the distinct folder path(s) of every entry in the table? For instance, if I have three files: "/Volumes/External HD/aFolder/aFile.pdf" "/Volumes/External HD/aFolder/anotherFile.pdf" "/Volumes/External HD/aFolder/aChildFolder/aThirdFile.pdf" the query would return: "/Volumes/External HD/aFolder/" "/Volumes/External HD/aFolder/aChildFolder/" Any ideas? Thanks again, John on 9/1/04 8:03 PM, Michael Kruckenberg at [EMAIL PROTECTED] wrote: > 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]