MySQL如何一行数据统计多个COUNT

SELECT count(CASE WHEN 字段 = '值' THEN 1 end) as 'A',
count(CASE WHEN 字段 = '值' THEN 1 end) 'B', count(CASE WHEN 字段 = '值' THEN 1 end) 'C' FROM table WHERE 条件