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;