如题,使用两次字符串截取函数。
SELECT
SUBSTRING_INDEX((SUBSTRING_INDEX(profile,',',-2)),',',1) as age,
count(*)
FROM user_submit
GROUP BY age;
如题,使用两次字符串截取函数。
SELECT
SUBSTRING_INDEX((SUBSTRING_INDEX(profile,',',-2)),',',1) as age,
count(*)
FROM user_submit
GROUP BY age;