题解 | #对过长的昵称截取处理#
对过长的昵称截取处理
https://www.nowcoder.com/practice/69243e2742bf47f1976db836860c123c
select uid, nick_name
from (
select uid,concat(substr(nick_name,1,10),'...') as nick_name
from user_info
where char_length(nick_name)>13
union
select uid,nick_name
from user_info
where char_length(nick_name)<=13
) as t
where char_length(nick_name) >10
order by uid
投递卓望公司等公司10个岗位
，姐姐你招我进去的你不记得吗
查看9道真题和解析