title: Multiple IF statements on MYSQL
body: <p>I'm trying to Display somes values in my database result, I am using this code but I can not succeed:</p>
  <pre><code>SELECT 
     item_code, 
     IF(category_code = 'HERR1', 'NO', 1) OR (category_code = 'COLN5', 'NO', 2) AS category_code, 
     item_name, 
     item_quantity 
  FROM qa_items
  </code></pre>
  <p><strong>EDIT :</strong>
  I Want to display for example:</p>
  <pre><code>If category_code = 'HERR1'
   Display = 1
  else if category_code = 'COLN5'
   Display = 2
  End If
  </code></pre>
  <p>If anyone has any idea, would greatly appreciate it</p>