题解 | #对过长的昵称截取处理#
对过长的昵称截取处理
https://www.nowcoder.com/practice/69243e2742bf47f1976db836860c123c
select uid,if(char_length(nick_name)>13, concat(substr(nick_name,1,10),'...'), nick_name) as nick_name from user_info where char_length(nick_name)>10
对过长的昵称截取处理
https://www.nowcoder.com/practice/69243e2742bf47f1976db836860c123c
select uid,if(char_length(nick_name)>13, concat(substr(nick_name,1,10),'...'), nick_name) as nick_name from user_info where char_length(nick_name)>10
相关推荐