题解 | #对过长的昵称截取处理#
对过长的昵称截取处理
https://www.nowcoder.com/practice/69243e2742bf47f1976db836860c123c
select
uid,
if (
#char_length()用来求出字符串长度
char_length(nick_name) > 13,
concat (substring(nick_name, 1, 10), '...'),
nick_name
) as nick_name
from
user_info
where
char_length(nick_name) > 10
查看2道真题和解析