Posted by Richard Lynch on 04/09/05 00:02

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

• Next in forum: Re: [PHP] Session Info Storage: Session File or MySQL DB?
• Prev in forum: Re: [PHP] pasring complex string question
• Thread view: Re: [PHP] mysql regexp select questions

[Reply to this message]