“-1”表示从后面开始取数，截取/后的字符串
select device_id,
substring_index(blog_url,"/",-1) user_name
from user_submit