# Revision history [back]

There are of examples in other forums, suggesting the ANY function is similar to IN and EXISTS and can be used in similar circumstances. ANY returns true on the first matched row, ALL returns false on the first non-match. Here is an example:

SELECT *
FROM "Tbl1"
WHERE "Col1" = ANY(SELECT 'str' FROM Tbl2)


The direct MySQL connector does not seem to allow the syntax, although MySQL does.

The syntax > ALL(SELECT Col1... is used as a synonym for > (SELECT MAX(Col1 ... with reference to numeric columns.