题解 | #对过长的昵称截取处理#
对过长的昵称截取处理
https://www.nowcoder.com/practice/69243e2742bf47f1976db836860c123c
SELECT
uid,
CASE
WHEN CHAR_LENGTH(nick_name) <= 13 THEN nick_name
ELSE CONCAT (LEFT (nick_name, 10), '...')
END AS nick_name
FROM
user_info
WHERE
CHAR_LENGTH(nick_name) > 10;
查看19道真题和解析