select device_id,regexp_replace(blog_url,'^.*url/','') as user_name from user_submit;