MySQL函数应用 Home » IDC云服务 » 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 ?