select device_id,
regexp_substr(blog_url,'[^/]+$') as user_name
from user_submit;