先截取后面两个,年龄和性别,再截取第一个年龄

SELECT
	substring_index( substring_index( PROFILE, ',',- 2 ), ',', '1' ) AS age,
	count( device_id ) 
FROM
	user_submit 
GROUP BY
	age