title: Replace "0" for "1" and "1" for "0" in the same SQL query
body: <p>I have a table named "emp" with the following data:</p>
  
  <pre><code>id        name   status
  1           x         0
  2           y         1
  3           z         0
  4           p         1
  </code></pre>
  
  <p>How to write a query to change status 0 into 1 and 1 into 0 in a single query? </p>