MySQL函数应用

MySQL函数使用

1、查询用户注册邮箱的种类

SELECT SUBSTRING_INDEX(email,'@',-1) mailbox,COUNT(SUBSTRING_INDEX(email,'@',-1))  FROM user_register WHERE email IS NOT NULL AND email<>'' GROUP BY mailbox