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

Question

I would like to group all the values ​​that are negative and all 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

Answer 3

Stefan . , 0 ,

GROUP BY `field` >= 0

Answer 4

- :

select count(*), IF(foo >= 0, "pos", "neg") as sign  from test group by sign;

foo -

EDIT: Stefan , , , .