Re: mysql regexp select questions
| From: | Richard Lynch | Date: | Fri, 08 Apr 2005 21:02:43 +0000 |
| Subject: | Re: mysql regexp select questions | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-212676@lists.php.net to get a copy of this message | ||
On Thu, April 7, 2005 5:32 pm, Andras Kende said:
>
> I would like to do the following:
>
> ============
> mysql db:
>
> andrew
> anthony
> joe
> janice
> john
> simon
> ============
>
> sql_query ( select names .....
>
> ============
>
> I would need only the distinct first character from the query
> result would be: a,j,s
>
> I think maybe its REGEXP but never did it before...
select distinct substring(name, 1, 1) from names
--
Like Music?
http://l-i-e.com/artists.htm