case when多个条件,一个表两个字段: type,status_case when type-CSDN博客

网站介绍:select case when vehicle_fence.type=0 and vehicle_fence.TriggleStatus=0 then 'inside' when vehicle_fence.type=0 and vehicle_fence.TriggleStatus=1 then 'outside' when vehicle_fence.type=_case when type