题解 | #截取出年龄#

select 
substring_index(substring_index(profile,',',-2) ,',',1) as age,
count(device_id) as number
from user_submit
group by age

如何截取文件路径中的age信息
1）substr(str,start,[,length])
substr(profile,12,2)

2)substring_index(str,delim,count)
双重截取
第一次截取：
substring_index(profile,",",-2)----27,male
第二次截取：
sustring_index(profile,",",1)---27

结合一起写
sustring_index(substring_index(profile,",",-2),",",1)