[luau] MySQL Querry Question

Kevin English Kevin at x5dev.com
Wed Feb 4 12:57:00 PST 2004


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
>
>
>
>




More information about the LUAU mailing list