select
uid,
case when char_length(nick_name)>13 then concat(left(nick_name,10),'...') 
else nick_name end nick_name
from 
user_info
where char_length(nick_name)>10