title: How to use Mysql SELECT CASE WHEN expression
body: <p>I am trying to use a select case statement on mysql DB.</p>
  
  <pre><code>SELECT 
  t.name, t.colour,
  CASE WHEN (Amount &lt; 0) AS small,  CASE WHEN (Amount &gt; 0) AS large FROM t
  </code></pre>
  
  <p>Error:
  ......for the right syntax to use near 'AS small, CASE (Amount > 0)</p>
  
  <p>I want my output like so</p>
  
  <pre><code>Name      Colour     Small     Large
  item1     red        -35
  item2     blue                 48
  etc. 
  </code></pre>
  
  <p>Been trying with no luck. Help please.</p>