mysql regexp select questions
| From: | Andras Kende | Date: | Fri, 08 Apr 2005 00:32:30 +0000 |
| Subject: | mysql regexp select questions | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-212603@lists.php.net to get a copy of this message | ||
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