mysql - 来自同一个表的多个 COUNT SELECTS

Question

如何在同一个表中执行多个 COUNT(*) SELECTS ...

$query = "SELECT count(*) FROM content_form WHERE read_flag = 0 ";  
$query = "SELECT count(*) FROM content_form WHERE read_flag = 1 "; 
$query = "SELECT count(*) FROM content_form WHERE read_flag = 0 ";

Answer 1

试试这个

SELECT read_flag,count(read_flag) as cnt FROM content_form WHERE read_flag IN (0,1,....) GROUP BY read_flag