试试这个：

select round_id from matches
where status in (3, 5)
group by round_id
having count(distinct status) > 1

你可以做：

select ( count(*) = sum(status in (3, 5)) ) as flag_3_5
from matches
where round_id = 28;

您可以使用 group by round_id .
mysql将布尔表达式视为数字上下文中的数字，true为“1”，false为“0”。所以， sum(status in (3, 5)) 统计具有这两种状态的行数。比较将检查这些是否都是行。

你可以用 exists :

select distinct m.round_id, (case when exists (select 1 
                                               from match m1 
                                               where m1.round_id = m.round_id and 
                                                     m1.status in (3,5)
                                               ) 
                                  then 'true' else 'false' 
                             end) as result
from match m
where round_id = 28;