select
    device_id,
    SUBSTRING_INDEX (blog_url, '/', -1) as user_name
from
    user_submit;