原文地址: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;
mysql> select coalesce(name,'总数'),sum(singin) as singin_total,count(*) from employee_tbl group by name e with rollup;
mysql> select name,sum(singin) as singin_total,count(*) from employee_tbl where name regexp '^小' group by name ;
mysql> select name,sum(singin) as singin_total,count(*) from employee_tbl where name regexp '明$';