I cannot visualize a reasonable way to do this via SQL. (I'm not saying there is NO way to do, but I don't see it.) If I were doing it I would re-design the data table to keep the file path and and file name in separate fields. Then I'd write a PHP or Perl script to extract the current data, parse it using a regexp function, then re-insert it into the database.
Many thanks for u reply. well these are the fields in table :
I already have a query that list songs by album .I have huge list of mp3 in diffrent folders some of them are collections from diffrent artis and albums and some does not have good tags so i want create seperate page using a query that list folders for me and then link that page to another page that lists songs inside that folder.
I use this getid3 php script that uploads for me song info to above db.That script does not put the foldernames as seperate field and it is huge program and hard to edit. I be happy if i find a way to over come problem or is there any php prog that stores folder names to current db since i easily can use one of empty fields for it ?Thanks