MySQL Group By Query X or not X

Question

这应该很容易，但我还没有找到答案。我有一个正在运行计数的查询，我想在查询中将其分组为 State = 1 和 State <>1 的那些，并计算每组的总和。

SELECT count(`id_job`) as count, `state` 
FROM job_table 
GROUP BY `state`;

Answer 1

您也可以查询 bool 表达式并对其进行分组:

SELECT   state = 1, COUNT(*)
FROM     job_table
GROUP BY state = 1