select case when TICKET_TYPE=1 then '是'
when TICKET_TYPE=2 then '不是'
when TICKET_TYPE=3 then '错误'
end as typestr
from client_exchange_ticket
select case when TICKET_TYPE=1 then '是'
when TICKET_TYPE=2 then '不是'
when TICKET_TYPE=3 then '错误'
end as typestr
from client_exchange_ticket