题解 | #截取出年龄#
# 字符串拆分 substring_index(str, delim, count)
select (substring_index(substring_index(profile, ',', -2) , ',', 1)) as age, count(device_id) as number
from user_submit
group by age;
# 字符串拆分 substring_index(str, delim, count)
select (substring_index(substring_index(profile, ',', -2) , ',', 1)) as age, count(device_id) as number
from user_submit
group by age;
相关推荐