# SUBSTRING_INDEX 按,分割
SELECT SUBSTRING_INDEX(profile,',',-1) as sex,COUNT(*) FROM user_submit GROUP BY sex
# 双重嵌套
select SUBSTRING_INDEX(SUBSTRING_INDEX
mysql split 方法使用
于 2022-02-12 19:50:03 首次发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)
# SUBSTRING_INDEX 按,分割
SELECT SUBSTRING_INDEX(profile,',',-1) as sex,COUNT(*) FROM user_submit GROUP BY sex
# 双重嵌套
select SUBSTRING_INDEX(SUBSTRING_INDEX