title: MYSQL REGEXP in "CASE WHEN"
body: <p>I would like to use REGEXP in a CASE WHEN context like this:</p>
  
  <pre><code>SELECT
  CASE title
    WHEN REGEXP '^(The Matrix|Riddick|American Pie)$' THEN (
      'Movie'
     ) ELSE (
      'FOOO'
     )
  END
  FROM `movies`
  </code></pre>
  
  <p>but this is not possible. I would like to match different strings here as you can see.</p>
  
  <p>Regards,
  Felix</p>