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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php