[luau] MySQL Querry Question

Maddog maddog at heavymetalradio.net
Wed Feb 4 13:16:00 PST 2004


----- Original Message ----- 
From: "Kevin English" <Kevin at x5dev.com>
To: <luau at videl.ics.hawaii.edu>
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
> LUAU at videl.ics.hawaii.edu
> http://videl.ics.hawaii.edu/mailman/listinfo/luau




More information about the LUAU mailing list