MySQL ANY, ALL
ALL operators can be used to compare operations on a single column value against a range of values.
The operator should have one of the following values (=, <>, !=, >, >=, <, or <=).
WHERE column_name operator ANY (value1, value2, value)
WHERE user_id > ANY (2,3,4,5,6)
SELECT column_name(s) FROM table_name WHERE column_name operator ANY (SELECT column_name FROM table_name WHERE condition);
Get the names if students whose score is greater than 75
SELECT student_name FROM students WHERE student_id = ANY (SELECT student_id FROM marks WHERE score > 75);