mysql case when語句

1.更新id=1的value為2，id不是1的value為0

update game set VALUE = (case id when 1 then 2 else 0  end)

2.更新id=1的value為3,value2為1，id不等于1的value為原值，value2為0

update game set VALUE = (case id when 1 then 3 else game.value end), VALUE2 = (case id when 1 then 1 else 0  end)