MySQL查询用户注册邮箱的种类的语句_MySQL
程序员文章站
2024-01-11 19:21:34
...
bitsCN.com
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 作者 SuperCustomer bitsCN.com
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 作者 SuperCustomer bitsCN.com