select stuname as 姓名,(case
when stuname like '%幂%' then '幂'
when stuname like '%峰%' then '峰'
end ) as 包含
from student where stuname like '%幂%'
or stuname like '%峰%' ;
when stuname like '%幂%' then '幂'
when stuname like '%峰%' then '峰'
end ) as 包含
from student where stuname like '%幂%'
or stuname like '%峰%' ;