题解 | #截取出年龄#
截取出年龄
https://www.nowcoder.com/practice/b8d8a87fe1fc415c96f355dc62bdd12f
SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(profile,',',-2),',',1) AS age,count(1) as number FROM user_submit GROUP BY age
需求分析:截取字符串,但要截取两次,才能搞到对应的字符串(这次不是首尾了)
解决思路:多次使用substring_index函数进行截取。