先截取出第二个逗号后面的字符串,再截图第一个逗号前的字符串 记得按年龄分组 select substring_index(substring_index(profile,",",-2),",",1) age, count(*) number from user_submit group by age