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);
select case sove when 1200 then 1 when 800 then 0 end from test_lxm;