case

case when大小比较

create table test_lxm(sove int);
insert into test_lxm values(1200),(800);
SELECT * FROM test_lxm;
UPDATE test_lxm set sove=(case when sove >1000 then 1 else 0end);

case when等值比较

select 
case sove 
when 1200 then 1
when 800 then 0
end
from test_lxm;