MySQL一个查询多个计数

Question

我试着统计每个月卖出了多少，然后得到一个Array。

$q = SELECT COUNT(id) AS January FROM tableName WHERE status='sold' AND month = '1'
UNION 
SELECT COUNT(id) AS February FROM tableName WHERE status='sold' AND month = '2'
$row = mysqli_fetch_array(mysqli_query($connection, $q));
print_r($row);

UNION不起作用，当我尝试print_r(数组(时，我得到的结果是

[Jenuary] => 200

如何在两个月内获得一个数组？

我想要结果：

[January] => 200,
[February] => 221

Answer 1

您可以尝试此查询以获得所需的确切结果。

select MONTHNAME(STR_TO_DATE(month, '%m')) as month, count(*) cnt
from tablename
where status = 'sold'
group by month

仅适用于特定月份的

select MONTHNAME(STR_TO_DATE(month, '%m')) as month, count(*) cnt
from tablename
where status = 'sold' and month in(1, 2)
group by month

Answer 2

我认为您想要条件聚合：

select sum(month = 1) as january, sum(month = 2) as february
from tablename
where status = 'sold' and month in (1, 2)

这只生成一行，其中有两列称为january和february，每列都包含当月的行数。

或者你可能想要每月一排。在这种情况下，您可以使用简单的聚合：

select month, count(*) cnt
from tablename
where status = 'sold' and month in (1, 2)
group by month