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)