[luau] MySQL Querry Question

[Maddog]

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

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freesoftwarehawaii.org/pipermail/luau-freesoftwarehawaii.org/attachments/20040204/8916d710/attachment-0001.htm>