title: issue in 'when in', converting SQL query to MYSQL
body: <p>i have a SQL query I am trying to convert to MYSQL
  I like the 'when...in' and i do not find a way to adapt it to mysql...</p>
  
  <pre><code>SELECT SUM
      (
      CASE
  
              WHEN tran_type IN (
                  'GAME_BET',
                  'GAME_WIN',
                  'ROLLBACK',
                  'CASH_OUT',
                  'STAKE_DEC',
                  'REFUND' 
                  ) THEN
                  ( amount_real ) 
                  WHEN tran_type IN ( 'BONUS_REL' ) THEN
                  (amount_released_bonus ) 
              END 
              ) 
      FROM
      datafeed
  </code></pre>