with cte as ( select device_id,substring_index(blog_url,'/',-1) as name from user_submit ) select device_id,concat(upper(left(name,1)),lower(right(name,length(name)-1))) as user_name from cte order by device_id desc