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

select uid, (case when char_length(nick_name) <= 13 then nick_name 
else concat(substring(nick_name,1,10),'...') end) as nick_name
from (
    select uid, nick_name
    from user_info
    where char_length(nick_name) > 10
) as a;