SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(profile,',',3),',',-1)AS age, COUNT(device_id) as number FROM user_submit GROUP BY age; --SUBSTRING_INDEX(profile,',',3) = 180cm,75kg,27 --SUBSTRING_INDEX(SUBSTRING_INDEX(profile,',',3),',',-1) = 27 SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(profile,',',-2),',',1)...