条件更新以更改SQL中的相同列

Question

id  name    status

1   abc 1
2   pqr 0

conditional update for same column

I want query like

update table set status = 1 Where id = 2 AND set status = 0 Where id != 2

is it possible to do with single query ?

Answer 1

UPDATE <table>
SET status = (CASE WHEN id = 2 THEN 1
                   ELSE 0 END)