title: MySQL Multiple condition on multiple columns in one case
body: <p>is that possible to get multiple condition on multiple columns in one case i tried using this.. it is not creating any error but result is not correct. should i use IF else?</p>
  
  <pre><code>SELECT 
    p.name,
    p.is_deleted,
  ( CASE WHEN pro.is_active = 1 THEN 'Active'
         WHEN pro.is_del = 1 THEN 'Not Active-Promotion Deleted'
         WHEN p.is_active = 0 THEN 'Not Active-Page Inactive'
         WHEN p.is_deleted = 1 THEN 'Not Active-Page Deleted'
    END) AS 'Status'
  FROM
    page_promotions pro 
    INNER JOIN pages p 
      ON pro.page_id = p.pages_id 
  </code></pre>
  
  <p><a href="http://i.stack.imgur.com/dHsqi.jpg" rel="nofollow">Expected and Current output</a></p>