经典sql语句，统计用户表中邮箱类别和数量

select count(id) as idcount,substring(email,(LOCATE( '@',email)+1)) from users where created < '2010-01-13 00:00:00' group by substring(email,(LOCATE( '@',email)+1)) order by idcount desc ;

转载于:https://blog.51cto.com/5iwww/267273