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]

Reply via email to