How to make a MySQL query with a selection of two values ​​\u200b\u200bat once?

Question

MySQL

-------------------
|  id_a  | id_b  |
-------------------
|    1   |   2   |
|    1   |   3   |
|    2   |   2   |
|    3   |   3   |
|    3   |   2   |
-------------------

I can't make an sql query to select those id_a for which id_b is equal to both 2 and 3.
Please help.

Answer 1

I'm not strong, but I did it like this.

SELECT f.id_a
FROM test AS f
  JOIN test AS s ON f.id_a = s.id_a
WHERE f.id_b = 2 AND s.id_b = 3;

I'm afraid it will be difficult to apply such a construction only to a large amount of data.