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