title: Update a boolean to its opposite in SQL without using a SELECT
body: <p>Is it possible to upgrade a bool field by telling it to update the field to the opposite of what it is without having to select the value - check it then update accordingly which seems long winded...</p>
  
  <p>A pseudo example of what i mean</p>
  
  <pre><code>UPDATE `table` SET `my_bool` = opposite_of(my_bool)
  </code></pre>
  
  <p>Currently i have to SELECT my_bool in one query then do a quick check on its value so i can update the table in a second query.</p>
  
  <p>I was hopeing to cut that down to a single query if that is possible ?</p>