----- Original Message ----- From: "Kevin English" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, February 04, 2004 1:03 PM Subject: Re: [luau] MySQL Querry Question
> 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 hahahahahahaha. My station is totally heavy music. www.heavymetalradio.net Thanks, MD > > > 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 > > > > > > > > > > _______________________________________________ > LUAU mailing list > [EMAIL PROTECTED] > http://videl.ics.hawaii.edu/mailman/listinfo/luau