title: SQLite multiple UPDATES in one query
body: <p>In table Colors, there is a Color column. I need to make 5 updates to the values in this column based on different conditions.</p>
  
  <pre><code>SET Color = 'Blue' WHERE Color = 'blue'  
  SET Color = 'Green' WHERE Color = 'green'  
  SET Color = 'Yellow' WHERE Color = 'yellow'  
  SET Color = 'Brown' WHERE Color = 'brown'  
  SET Color = 'Orange' WHERE Color = 'orange'
  </code></pre>
  
  <p>Can I make these 5 updates to the table in one query? </p>
  
  <p><strong>Note:</strong> my real values are more complex than this, so disregard simple functions to make the values uppercase</p>