The syntax look something like this UPDATE tablename SET filename=desired_filename WHERE first_two_equal_X: Luis ----- Original Message ----- From: <dsig@teleport.com> To: <php-windows@lists.php.net> Sent: Friday, November 14, 2003 4:26 PM Subject: script to update file names > I have a db in mysql which has all of my mp3s listed (approx 180 gig > worth). > > I have need to restructure the physical location and so need to change > the info in the db. > > if table looks like > ID (seq) > filename (x:\my music\artist - album\01. my song.mp3) > > I need to change at least the x and hopefully the x:\my music > > I have tried several things and does not *seem* to work. Not sure why I am having this problem .. seems pretty straight forward <g> > > anyone with a simple script I could use / pilfer / modify ? > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
