```WITH t AS ( SELECT uid, nick_name, CHAR_LENGTH( nick_name ) len FROM user_info ) SELECT
uid,
IF
	( len > 13, CONCAT( LEFT ( nick_name, 10 ), '...' ), nick_name ) nick_name 
FROM
	t 
WHERE
	len > 10;