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
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
- 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
do a file replace.
-Original Message-
From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Maddog
Sent: Wednesday,
February 04, 2004 10:26 AM
To: [EMAIL PROTECTED]
Subject: [luau] MySQL Querry
Question
Any MySQL masters out there? I have
a song DB on my old radio station