Extract 1st word from mysql database field

[overflo]

I need to get the first word from a field and separate it from the rest of the words and have no idea where to start. Any help would be greatly appreciated.

 

[overflo]

And I need to put the firstword into a variable and also any other words after that.
i.e. $firstword =
$rest =

 

[overflo]

worked it out. Here it is if anyone wants to know

//tell it what character we're looking for
//i.e. space and take the string up to that
$position = strpos($title, ' ');
if ($position !== FALSE){
$first = substr ($title, 0, $position);
}else{
//in case there is only one word
       $first = $title;
}
// now take the string from after the first space
       $rest = strstr($title, ' ');

 

[KarveR]

from mysql I'd have used a query like this:

select *,substring(title,1,instr(title,' ')) as titleword   from mytable;

This will return a result set of all the fields in the table and a field created from the first word in `title`.

Then all you do is standard while loop to step through the results and display them...

MySQL questions are always best asked in here

http://tek-tips.com/threadminder.cfm?pid=436

but your solution is oddly php based when you asked for mysql solution

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.