php - split a column value based on a delimiter? -

suppose have entries under column 'url' so:

---

url

---

"get /books/fiction?id=324223"
"get /classroom/ http/1.0"
"get /register.php http/1.0"
"post /thankyou.php http/1.0"
"get /register.php?error=alreadyregistered http/1.0"
"post /processlogin.php?next=%2fregister.php%3ferror%3dalreadyregistered http/1.0"
"get /register.php?error=alreadyregistered http/1.0"
"get /books/fiction?id=324273"

i need query me words enclosed in first pair of slashes ,'/' url. eg. 'classroom','register' etc...

and entries arent limited these.. i'd need generic query rather specific one..help?

this should trick (if understand question correctly):

$request = "get /books/fiction?id=324223";  // captures uri request string $request_array = explode( ' ', $request ); $request_uri = $request_array[ 1 ];  // captures between / , . or / preg_match( '#\/(.*?)[./]#', $request_uri, $matches);  var_dump($matches);