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

加深印象substring_index(a,b,c),截取字符串函数