- case
有order_status表status有三种状态 ,1:未审核 2:已审核 3:已驳回
select status,
case
when `status`=1 then '未审核'
when `status`=2 then '已审核'
else '默认'
end as new_name
from order_status;
有order_status表status有三种状态 ,1:未审核 2:已审核 3:已驳回
select status,
case
when `status`=1 then '未审核'
when `status`=2 then '已审核'
else '默认'
end as new_name
from order_status;