MySql SET intersection

Question

I have next database

|   ID   |  numbers   |
|--------|------------|
|    1   | 1,2,3      |
|    2   | 4,5,6      |
|    3   | 2,3,4      |

To retrieve all rows where numbers holds a given number is easy:

SELECT * FROM mydb WHERE FIND_IN_SET(3, numbers)

This returns row 1 and 3

But now I want to pass an array/set of numbers and want to retrieve all entries where at least one number occurs in numbers, i.e. where the intersect of both sets is not empty Something like:

SELECT * FROM mydb WHERE SET_INTERSECT('2,4', numbers)!=NULL

This should return all rows because every row holds 2 and/or 4.

The above doesn't work. Is this possible in mysql?

Thanks!

Answer 1

Why not use OR ?

SELECT * FROM mydb WHERE FIND_IN_SET(2, numbers) or FIND_IN_SET(4, numbers)