题解 | #对过长的昵称截取处理#

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;