从数据里面截取出内容来,还得是看substring_index函数,左两次substring_index就可以了。

select 
    substring_index(substring_index(profile, ',', 3), ',', -1) as age,
    count(*) as number
from user_submit
group by age;