goback add

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

3673 点击·0 回帖
灯火互联
灯火互联
楼主


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  





喜欢0 评分0
回复

切换至电脑版

Powered by phpwind.me ©2003-2014