Re: Last Name extraction in query

good point. So wrapped up in making my php script work that I didn't think about that. "Ashley Sheridan" <ash@ashleysheridan.co.uk> wrote in message news:1301936583.2288.3.camel@localhost... > 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 > > >