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

• Next in forum: Re: [PHP] another non php Q
• Prev in forum: Re: [PHP] insert mysql data with safe mode on problem
• Thread view: mysql regexp select questions

[Reply to this message]