How to change all other rows except the row selected by id
<p>I have this table bellow.</p>

<pre><code>id      title     name    active
_____   ______    _____   _____

1       kdfl      lsdf    0
2       ksdl      klsd    1
3       ewrl      oxcl    0
</code></pre>

<p>I want to query the table so that when I get the id and change the active column to 1 all the other rows active columns change to 0. Conversely if I set it to 0, all the others would change to 1.</p>

<p>I have tried this particular query </p>

<p><code>UPDATE themes SET active = 1 WHERE id = 3, SET active = 0 WHERE id = 2</code></p>