MySQL 8.0

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

CREATE TABLE numbers( i integer);

INSERT INTO numbers(i) VALUES(1);
INSERT INTO numbers(i) VALUES(2);
INSERT INTO numbers(i) VALUES(3);
INSERT INTO numbers(i) VALUES(4);
INSERT INTO numbers(i) VALUES(5);
INSERT INTO numbers(i) VALUES(6);
INSERT INTO numbers(i) VALUES(7);
INSERT INTO numbers(i) VALUES(8);
INSERT INTO numbers(i) VALUES(9);
INSERT INTO numbers(i) VALUES(10);

SELECT * FROM numbers;

i

1

2

3

4

5

6

7

8

9

10

SELECT *
FROM numbers
WHERE i in (SELECT 3 UNION ALL SELECT 5 UNION ALL SELECT 7)

i

3

5

7

SELECT *
FROM numbers
WHERE i < SOME (SELECT 3 UNION ALL SELECT 5 UNION ALL SELECT 7)

i

1

2

3

4

5

6

SELECT *
FROM numbers
WHERE i < ANY (SELECT 3 UNION ALL SELECT 5 UNION ALL SELECT 7)

i

1

2

3

4

5

6

SELECT *
FROM numbers
WHERE i <= ANY (SELECT 3 )

i

1

2

3

SELECT *
FROM numbers
WHERE i <= SOME (SELECT 3 )

i

1

2

3