题解 | #对过长的昵称截取处理#
对过长的昵称截取处理
https://www.nowcoder.com/practice/69243e2742bf47f1976db836860c123c
select
uid,
if(char_length(nick_name) <= 13, nick_name, concat(substr(nick_name, 1,10),'...')) as nick_name
from user_info
where char_length(nick_name) > 10