MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE test ( id INT, s VARCHAR(255));
INSERT INTO test VALUES
(  1 , '2'    ),
(  2 , '1'    ),
(  3 , '2'    ),
(  4 , '2,3'  ),
(  5 , '1,3'  ),
(  6 , '1,2,5'),
(  7 , '4,5'  ),
(  8 , '3,4'  );
SELECT * FROM test;

Records: 8  Duplicates: 0  Warnings: 0




id
s


1
2

2
1

3
2

4
2,3

5
1,3

6
1,2,5

7
4,5

8
3,4


SELECT *
FROM test 
WHERE JSON_OVERLAPS(CONCAT('[', test.s, ']'), '[5,3,1]')


id
s


2
1

4
2,3

5
1,3

6
1,2,5

7
4,5

8
3,4


SELECT *
FROM test 
WHERE JSON_OVERLAPS(CONCAT('[', test.s, ']'), '[4,5]')


id
s


6
1,2,5

7
4,5

8
3,4