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