title: Updating a column based on another column
body: <p>I have the following table:</p>
  
  <pre><code>ID  Type    Food    Drink   Animal
  --------------------------------------
  1   NULL    Y   N   N
  2   NULL    Y   N   N
  3   NULL    N   Y   N
  4   NULL    N   Y   N
  5   NULL    N   N   Y
  </code></pre>
  
  <p>How can I update the Type column based on what boolean is true in other columns. For example
  If the 'Food' column is true then the Type would be 'Food' etc</p>