title: case when else mysql with same column with multiple where conditions
body: <p>I've a table data . I'm trying to get the data based on three  where conditions for the same column using case when mysql query .
  But not giving the results as expected .
  My table :</p>
  
  <pre><code>id  bundle_id   asset_id    price_id    customer_id  weekday_am     weekend_am 
  1       1           1           1                       100.00          120.00
  2       1           2           1                       150.00          140.00
  3       1           1           1                       0.00            0.00
  4       1           1           2                       0.00            145.00
  5       1           2           2                       140.00          0.00
  6       1           1           2                       0.00            0.00
  7       1           1           3           5           140.00          120.00
  8       1           2           3           5           0.00            140.00
  9       1           1           3           5           130.00          0.00
  </code></pre>
  
  <p>and i want the results as like below formatted.</p>
  
  <pre><code>bundle_id   asset_id    weekday_am      weekend_am
  1           1               140.00          120.00
  1           2               150.00          140.00
  1           1               130.00          0.00
  </code></pre>
  
  <p>But my query is not working :</p>
  
  <pre><code>SELECT bundle_id,asset_id ,
  (CASE 
  WHEN weekday_am IS NULL  or weekday_am = 0.00  where customer_id = 5 and price_id = 3 THEN weekday_am
  WHEN weekday_am IS NULL  or weekday_am = 0.00 where price_id = 2 THEN weekday_am  
  ELSE weekday_am IS NULL  or weekday_am = 0.00 where price_id = 1 THEN weekday_am  
  END as 'weekday_am'),(CASE 
  WHEN weekend_am IS NULL  or weekend_am = 0.00 where customer_id = 5 and price_id = 3 THEN weekend_am
  WHEN weekend_am IS NULL  or weekend_am = 0.00 where price_id = 2 THEN weekend_am  
  ELSE weekend_am IS NULL  or weekend_am = 0.00 where price_id = 1 THEN weekend_am  
  END as 'weekend_am')
  FROM 
  bundle_prices where bundle_id = 1
  </code></pre>
  
  <p>Can somebody  please help me with this ? Thank you .</p>