oracle case when
参考 https://blog.****.net/yangzjchn/article/details/81019449
select case
when t.content = '1' then
'满意'
when t.content = '2' then
'一般'
else
'不满意'
end satis
from satisfaction t;