题解 | #对过长的昵称截取处理#

select uid, nick_name
from (
    select uid,concat(substr(nick_name,1,10),'...') as nick_name
    from user_info
    where char_length(nick_name)>13
    union 
    select uid,nick_name
    from user_info
    where char_length(nick_name)<=13
) as t
where char_length(nick_name) >10
order by uid