mysql统计某个字段不同值的个数

对资讯表的state_dict进行统计，0代表待审核，1代表审核通过，2代表审核不通过

1、Mapper文件以List<Object>接收

SELECT
            a.state_dict,
            COUNT(a.state_dict) AS "count"
        FROM
            news a
        GROUP BY
            state_dict

2、Mapper文件以Map<String,Object>接收，便于页面取值

 

SELECT
    IFNULL(SUM(c.count), 0) AS 'total',
    max(CASE WHEN c.state_dict = 0 THEN c.count ELSE 0 END)"auditCount",
    max(CASE WHEN c.state_dict = 1 THEN c.count ELSE 0 END)"throughAuditCount",
    max(CASE WHEN c.state_dict = 2 THEN c.count ELSE 0 END)"auditFailedToPassCount"
FROM
    (
        SELECT
            a.state_dict,
            COUNT(a.state_dict) AS "count"