How to group records by using regular expression?

Hi Everybody I need to group records by regular expression Example: Table has column - names (just example) records are: idnames time 1 John, Max 12:15 2 Max, Jeff 15:55 3 Ken 20:45 I need to get grouped records by name Max in column names SELECT

Re[2]: How to group records by using regular expression?

something like (yes|no|may be|can not|uknown|.) or MySQL are able to group it fast enough? faster than PHP? Thanx TC On Saturday, April 02, 2005 01:51, ON.KG wrote: Hi Everybody I need to group records by regular expression Example: Table has column - names (just example