Could you explain that query a little more please?
Tryst
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
The syntax look something like this
UPDATE tablename SET filename=desired_filename WHERE first_two_equal_X:
Luis
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, November 14, 2003 4:26 PM
Subject: [PHP-WIN] 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 hop
