title: how to update one record column to true, all else false
body: <p>I am trying to update a column in a record to true to indicate that the record is the one active in the table.  However, by updating this record, I must then update all other records for that column to false.  Is there a way to do this in one SQL statement?  I can do it in two statements like this:</p>
  
  <pre><code>UPDATE My_Table
  SET is_group_active = 0
  
  UPDATE My_Table
  SET is_group_active = 1
  WHERE group_id = 2;
  </code></pre>