script to update file names
| From: | dsig at teleport dot com | Date: | Thu, 01 Jan 1970 00:00:00 +0000 |
| Subject: | script to update file names | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-22097@lists.php.net to get a copy of this message | ||
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 ?