how to query to get artistname and artist album

[DavidTigerch]

Hi all i got a table called music and it has three fields called :

url,album,artist

Currently there is only data in url field and the data inside is like this

[URL unfurl="true"]http://music.localhost.com/TtdlI3l1lIl0OOO0a/[/URL][b]artistname[/b]/[b]albumname[/b]/life too short.mp3

the artist and album feilds are empty at this moment!!. What i want for each record the value of artist and album which is shown in bold(the artist name and albumname is part of url column value) copied and placed in its artist and ablum field in the same row .I want this for all records in my db. I be happy if an expert show me how that can be done using mysql .Thanks

Rephrase:
A query that gets artistname and albuname from url feild and put them in artist and album feided for
each row of data in mysql db.

 

[TonyGroves]

You could use the SUBSTRING_INDEX function. It's described in the manual.

 

[DavidTigerch]

man could u just show me how i am not an sql expert.thanks

 

[TonyGroves]

If you show us what you've tried, somebody might be able to help you improve it.

 

[guelphdad]

Look in the manual under STRING FUNCTIONS. There you will see SUBSTRING_INDEX as Tony suggested. You are here asking for help. You need to do a little bit of legwork too.

 

[DavidTigerch]

Resolved!