mysql - 获取同一列的总计，但每个 SELECT 别名都包含一个特定的字符串

Question

我想检索同一列的总计，但每个别名包含不同的字符串？我该怎么做，下面的子查询失败了。

SELECT status (
    SELECT COUNT(status) FROM `table`
    WHERE `status` LIKE LOWER('%stage 1%')
    ) AS Stage1,
status (
    SELECT COUNT(status) FROM `table`
    WHERE `status` LIKE LOWER('%stage 1%')
    ) AS Stage2,
status (
    SELECT COUNT(status) FROM `table`
    WHERE `status` LIKE LOWER('%stage 1%')
    ) AS Stage3
FROM `table`

Answer 1

如果您想要三列，请使用条件聚合。这在 MySQL 中特别容易:

select sum(status LIKE LOWER('%stage 1%')) as status1,
       sum(status LIKE LOWER('%stage 2%')) as status2,
       sum(status LIKE LOWER('%stage 3%')) as status3
from `table`;