知识

SQL 入门 32 #截取出年龄#

https://blog.nowcoder.net/n/08a3a1df016d418daabd4a0870f7fb4e

题解

SELECT device_id,SUBSTRING_INDEX(blog_url,'/',-1) AS user_name
FROM user_submit