[mysql]MySQL查询用户注册邮箱的种类的语句

MySQL查询用户注册邮箱的种类的语句

查询用户注册邮箱的种类

Sql代码  

SELECT SUBSTRING_INDEX(email,'@',-1) mailbox,

COUNT(SUBSTRING_INDEX(email,'@',-1))  

FROM user_register WHERE email IS NOT NULL AND email<>''

GROUP BY mailbox