Split a string and find the last split?

[joecooper]

I have a database full of around 30,000 urls. Each url is like this, but some have less folders, some more.

 

"http://www.site. net/Music/artist/Album/Song.mp3"

 

I need to split each of the file names into a seperate feild in the database.

 

My code so far:

 

$query = sprintf("select * from urls");
$result = mysql_query($query, $link);

if ($result) {
   while($row = mysql_fetch_array($result)) {
        $fullurl = $row['url'];
   }
}else{
   echo mysql_error();
}

 

How can I split the string so that anything after the last "/" gets added into the new feild. I know the MySQL side, just not how to split to the last "/".

 

Thanks

 

Joe

Edited March 31, 2013 by joecooper

[Jessica]

Explode and array_pop