题解 | #对过长的昵称截取处理#
对过长的昵称截取处理
http://www.nowcoder.com/practice/69243e2742bf47f1976db836860c123c
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;
