On Mon, 2011-04-04 at 11:50 -0400, Jim Giner wrote:
> having a problem posting this message - forgive any duplication please.
>
> Hi,
> I'm trying to use sql to extract the last name from a person's name field in
> my table. Here's my Select:
>
> $q = "SELECT race_winner,count(race_date) as wins,
> substr(race_winner,FIELD(' ',race_winner)) as last_name
>
> etc.,,,
>
>
>
> My result keeps coming up with a 0 for the FIELD portion I assume
> since my output shows a blank last_name. From the docs I believe it should
> be giving me the right-most portion of the 'race_winner' field beginning
> where the first space char is found.
>
> Am I not using this correctly? Is there a better way to do this? I'm
> trying to have my results sorted by last name and since the table was not
> built with separate first/last name fields, I'm stuck with figuring
> somethign out.
>
>
>
>
>
Where's the PHP question in this, as what you've asked would be better
asked on a database list, as it's an SQL query.
Thanks,
Ash
http://www.ashleysheridan.co.uk
