先截取后面两个,年龄和性别,再截取第一个年龄
SELECT
substring_index( substring_index( PROFILE, ',',- 2 ), ',', '1' ) AS age,
count( device_id )
FROM
user_submit
GROUP BY
age

先截取后面两个,年龄和性别,再截取第一个年龄
SELECT
substring_index( substring_index( PROFILE, ',',- 2 ), ',', '1' ) AS age,
count( device_id )
FROM
user_submit
GROUP BY
age