MySql, how can I group by, in a select query on positve or negative?

Question

I would like to group by all the the values which are negative and all those which are positive, any ideas how to do this ?

Answer 1

GROUP BY SIGN(field) should work.

Answer 2

SELECT SUM(CASE WHEN SomeColumn < 0 THEN 1 ELSE 0 END) AS negative_values,
       SUM(CASE WHEN SomeColumn >=0 THEN 1 ELSE 0 END) AS non_negative_values
    FROM YourTable