题解 | #提取博客URL中的用户名#

1. 从最后一个 / 处截取字符串 substring_index函数

select
us.device_id,substring_index(us.blog_url,'/',-1) as user_name
from user_submit us 

2. 替换掉前面的字符串 replace()函数

select
us.device_id,replace(us.blog_url,'http:/url/','') as user_name
from user_submit us 

3. 删除前面的字符串 trim()函数

select
us.device_id,trim('http:/url/' from us.blog_url) as user_name
from user_submit us