MySQL查询用户注册邮箱的种类的语句
查询用户注册邮箱的种类
Sql代码
SELECT SUBSTRING_INDEX(email,'@',-1) mailbox,
COUNT(SUBSTRING_INDEX(email,'@',-1))
www.2cto.com
FROM user_register WHERE email IS NOT NULL AND email<>''
GROUP BY mailbox
GROUP BY mailbox
作者 SuperCustomer