題解 | #截取出年齡#
截取出年齡
http://www.fangfengwang8.cn/practice/b8d8a87fe1fc415c96f355dc62bdd12f
substring_index套娃解決
select age, count(age) FROM (select substring_index(substring_index(profile,',',-2),',',1) "age" from user_submit) t group by age order by age desc