title: Case when then, but with AND condition inside when and before then
body: <p>In the below query I want to add an AND condition inside the CASE's WHEN and before THEN is that possible?</p>
  
  <p>for example  WHEN 'r' AND table1.name="jones" THEN 'very high'</p>
  
  <pre><code>SELECT table1.id, table1.name,
     CASE table1.event
       WHEN 'r' THEN 'very high'
       WHEN 't' THEN 'very low'
       ELSE (SELECT table2.risk FROM table2 WHERE table2.value &lt;= table1.value
             ORDER BY table2.value DESC LIMIT 1)
     END AS risk
  FROM table1
  ORDER BY FIELD( table1.event, 'r', 'f', 't' ), table1.value DESC
  </code></pre>