题解 | #对过长的昵称截取处理#
对过长的昵称截取处理
https://www.nowcoder.com/practice/69243e2742bf47f1976db836860c123c
select uid, case when char_length(nick_name)>13 then concat(substr(nick_name, 1, 10), '...') else nick_name end as nick_name from user_info where char_length(nick_name)>10;
需要注意字符长度用char_length()函数来计算，而length()是用来计算字节长度的。不要混淆了！！！
