How to use Mysql SELECT CASE WHEN expression
<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>