题解 | 对过长的昵称截取处理
对过长的昵称截取处理
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
相关推荐