Posted by Andras Kende on 04/08/05 03:32

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

[Back to original message]