How to make a selection based on two conditions of one field?

Question

MySQL

There is such a table ...
you need to get all id_users that were at the point id_ap = 1 and at id_ap = 118 with one query
separately WHERE id_ap= 1 - 366 lines
WHERE id_ap = 118 - 1120 lines
made such a request ... but I don’t understand a little it
displays 308 lines ... that is, it counts only those who were at 1 by 118, but it is necessary that everyone take
SELECT vizits.id_user, id_ap FROM vizits WHERE id_ap IN (1,118) GROUP BY id_user HAVING COUNT(id_ap)=2

Answer 1

if both on that and on that - then HAVING COUNT(DISTINCT id_ap) = 2, if on any - then generally remove having

Answer 2

If I understand correctly what you want, then notWHERE id_ap IN (1,118)
WHERE id_ap = '1' OR id_ap = '118')