原文地址：http://www.runoob.com/mysql/mysql-regexp.html

mysql> select coalesce(name,'總數(shù)'), count(*),sum(singin) as singin_total from employee_tbl group by namme with rollup;

復(fù)合查詢1

mysql> select coalesce(name,'總數(shù)'),sum(singin) as singin_total,count(*) from employee_tbl group by name e with rollup;

復(fù)合查詢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