Posted by Eli on 04/08/05 07:06

Andras Kende wrote:
> 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...
>
> Thanks!!
>
> Andras Kende


Try the query (no REGEXP):

SELECT DISTINCT SUBSTRING(names,0,1) FROM .....

• Next in forum: Re: Smart Trimming of UTF-8 Entities for Database
• Prev in forum: Smart Trimming of UTF-8 Entities for Database
• Thread view: Re: mysql regexp select questions

[Reply to this message]