如题,使用两次字符串截取函数。

SELECT 
SUBSTRING_INDEX((SUBSTRING_INDEX(profile,',',-2)),',',1) as age,
count(*)
FROM user_submit
GROUP BY age;