How to ommitt part/word of query result?

[PHPAnx]

Trying to figure out how to leave out part of query result. For example:

$roo = cd all
$roo = video all
$roo = record all
$roo = dvd all

When I echo $roo I just want the first word and don't want to display "all"

How can I do this??

Thanks

[volleytotal_ch]

$roo = str_replace("all","",$roo);

[PHPAnx]

Perfect, I had it backwards. Thanks!!