Re: [PHP] mysql regexp select questions

2005-04-08 Thread Richard Lynch
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 quer

[PHP] mysql regexp select questions

2005-04-07 Thread Andras Kende
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... Tha