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

select uid,
if (char_length(nick_name)>13,concat(substring(nick_name,1,10),"..."),nick_name) as nick_name
from user_info
where char_length(nick_name)>10;

重点一：字符的长度函数char_length(nick_name)

重点二：if 函数的应用，若char_length(nick_name)>13，则拼接前十位加‘’。。。‘’concat(substring(nick_name,1,10),"...")，否则，输出原样nick_name

if (char_length(nick_name)>13,concat(substring(nick_name,1,10),"..."),nick_name)