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

SELECT uid, RPAD( LEFT(nick_name,10),13,'.') FROM user_info WHERE CHAR_LENGTH(nick_name) > 13 UNION SELECT uid,nick_name FROM user_info WHERE CHAR_LENGTH(nick_name) BETWEEN 10 AND 13 order by uid;