MySQL SQL

MySQL ANY

Compare a value with one or more values returned by a subquery.

SELECT * FROM products
WHERE price > ANY (SELECT price FROM clearance_products);

The comparison is true if it succeeds for at least one subquery value.