题解 | #对过长的昵称截取处理#char_length
对过长的昵称截取处理
https://www.nowcoder.com/practice/69243e2742bf47f1976db836860c123c
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;
查看6道真题和解析