you've got the right idea... u could also try something like: UPDATE songlist SET filename = replace(Filename, 'F:\Heavy\', 'E:\music') WHERE substr(Filename,1,8) = 'F:\Heavy'
take a look at string functions: http://www.mysql.com/doc/en/String_functions.html why is it not suprising that the guy named "mad dog" is listening to heavy music..... k > Any MySQL masters out there? I have a song DB on my old radio station > server which had songs in different folders spread across 3 drives. > > F:\Heavy > F:\Music > G:\New Downloaded Music > and > I:\Music > > I have gathered website addresses Buy CD links and album cover art for all > of those songs. I built a new server which is now running the station. All > the songs are located on one drive in E:\Music > > I need to create an Update sql querry that will update the old file > locations to the new one so i can then export the data from the old DB and > import it into the new db. > > Can someone help me with this? Here is what i came up with but I don't > know if this will work, guess I don't trust myself :-) > > UPDATE songlist SET filename = 'E:\music\'+SUBSTR(Filename,8,200) > > WHERE > > substr(Filename,1,8) = 'F:\Heavy' > > Then just change the original file location and run the SQL querry again? > > Thanks, > > Don > > > >