select auditing=case when auditing=0 then '未审核' else '已审核' endfrom sys_order_details
select auditing , case when auditing = 1 then '已审核' else '未审核' end from sys_order_details select auditing , case when auditing = 1 then '已审核' when 0 then '未审核' else '' end from sys_order_details
select case auditing when 0 then 未审核 else 已审核 end as auditing from sys_order_details
auditing=case when auditing=0 then '未审核' else '已审核' endfrom sys_order_details
select case auditing when 0 then 未审核 else 已审核 end as auditing
from sys_order_details