<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1276" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>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.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>F:\Heavy</FONT></DIV>
<DIV><FONT face=Arial size=2>F:\Music</FONT></DIV>
<DIV><FONT face=Arial size=2>G:\New Downloaded Music </FONT></DIV>
<DIV><FONT face=Arial size=2>and</FONT></DIV>
<DIV><FONT face=Arial size=2>I:\Music</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>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</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>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.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>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
:-)</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2>
<P>UPDATE songlist SET filename = 'E:\music\'+SUBSTR(Filename,8,200) </P>
<P> WHERE</P>
<P> substr(Filename,1,8) = 'F:\Heavy'</P>
<P><FONT face=Arial>Then just change the original file location and run the SQL
querry again?</FONT></P>
<P><FONT face=Arial>Thanks,</FONT></P>
<P><FONT face=Arial>Don</FONT></P></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2><A
href="http://www.heavycore.org"></A></FONT> </DIV></BODY></HTML>