Hi Everybody

I need to group records by regular expression

Example:

Table has column - names (just example)
records are:

id    names         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 COUNT(*)
FROM my_table
GROUP BY <reg_expression>

Could somebody help me?

Thanx


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to