原文地址：http://www.runoob.com/mysql/mysql-regexp.html
mysql> select coalesce(name,'总数'), count(*),sum(singin) as singin_total from employee_tbl group by namme with rollup;
复合查询1
mysql> select coalesce(name,'总数'),sum(singin) as singin_total,count(*) from employee_tbl group by name e with rollup;
复合查询2
mysql> select name,sum(singin) as singin_total,count(*) from employee_tbl where name regexp '^小' group by name ;
正则匹配1
mysql> select name,sum(singin) as singin_total,count(*) from employee_tbl where name regexp '明$';
正则匹配2
网友评论