mysql> select
count(distinct left(email,4)）as L4,
count(distinct left(email,5)）as L5,
count(distinct left(email,6)）as L6,
count(distinct left(email,7)）as L7,
from SUser;
版权声明：本文为weixin_33669968原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。