I have this query:
SELECT (COUNT(*) = SUM(status in (3, 5)) ) AS result FROM `match` WHERE round_id = 15
this essentially check if the table match
have all the items with a status 3
or 5
for the round 15
. This works, but I actually want add another condition, in particular if the result
is true
I want check that all the records of that table with round_id = 15
are 20
. How can I perform this?
Advertisement
Answer
Is this what you want?
SELECT (COUNT(*) = SUM(status in (3, 5)) AND COUNT(*) = 20) AS result FROM `match` WHERE round_id = 15;
This checks that there are 20 rows that match the conditions.