select substring(replace(sub,substring_index(sub,",",-1),""),1,length(replace(sub,substring_index(sub,",",-1),""))-1) age ,count(*) as number from ( select substring_index(profile,",",-2) sub from user_submit ) s group by age 屎山,但有效