Re: Last Name extraction in query
| From: | Bastien Koert | Date: | Mon, 04 Apr 2011 20:06:28 +0000 |
| Subject: | Re: Last Name extraction in query | ||
| References: | 1 2 3 4 5 6 7 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-312261@lists.php.net to get a copy of this message | ||
On Mon, Apr 4, 2011 at 2:40 PM, Steve Staples <sstaples@mnsi.net> wrote:
> On Mon, 2011-04-04 at 14:06 -0400, Jim Giner wrote:
>> no - that address came back undeliverable.
>> >
>> > To subscribe to the list, send an empty message to
>> > <mysql-subscribe@lists.mysql.com>
>> >
>> > Marc
>>
>>
>>
> http://lists.mysql.com/mysql
>
> there is the subscribe box on the right side... use that. they are a
> helpful bunch over there.
>
> --
>
> Steve Staples
> Web Application Developer
> MNSi (Managed Network Systems Inc.)
> 519.258.2333 x8414
> http://www.mnsi.net
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
Try using LOCATE instead of the FIELD function
$q = "SELECT race_winner,count(race_date) as wins,
substr(race_winner,LOCATE(' ',race_winner)) as last_name
--
Bastien
Cat, the other other white meat