mysql case when 用法

select

(case  when DB1_DF762 = 0 then MDF108 else DB1_DF762 end)

from yzzy where create_time>'2022-06-28 16:46:00' and create_time < '2022-06-28 16:48:00'

当DB1_DF762等于0时  取MDF108的值  否则取DB1_DF762的值