title: MYSQL - Update values of new column based on condition
body: <p>I have the following table</p>
  
  <pre><code>+--------------+------------+------+-----+---------+-------+
  | Field        | Type       | Null | Key | Default | Extra |
  +--------------+------------+------+-----+---------+-------+
  | image_id     | int(11)    | YES  |     | NULL    |       |
  | image_status | bit(3)     | YES  |     | NULL    |       |
  | image_result | varchar(4) | YES  |     | NULL    |       |
  +--------------+------------+------+-----+---------+-------+
  </code></pre>
  
  <p>image_id and image_status columns are populated with values. The values in image_result are all NULL.</p>
  
  <p>I want to insert the following values into the image_result column based on the following conditions (I want to update all the rows in the table)- </p>
  
  <ul>
  <li>if image_status = '0' OR image_status = '3' then image_result =
  'Pass'</li>
  <li>if image_status = '1' OR image_status = '4' then image_result =
  'Warn'</li>
  <li>if image_status = '2' then image_result = 'Fail'</li>
  </ul>
  
  <p>How do I do the above?</p>