Description\n-----------\n\nSyntax\n\nSOME is a synonym for ANY.&#x20;\n\n``sql\nscalar_expression comparison_operator ANY <Table subquery>\nscalar_expression comparison_operator SOME <Table subquery>\n`\n\n scalar_expression may be any expression that evaluates to a single value.\n comparison_operator may be any one of =, >, <, >=, <=, <> or !=.\n\nAbout IN\n\nAlthough IN functions similarly to = ANY, it is documented separately due to unique optimization characteristics. Refer to Subqueries with IN and NOT IN for more details.\n\nANY or SOME returns:\n\n TRUE if the comparison operator returns TRUE for at least one row returned by the table subquery.\n FALSE if the comparison operator returns FALSE for all rows returned by the table subquery, or if the table subquery has no rows.\n* NULL if the comparison operator returns NULL for at least one row returned by the table subquery and doesn't returns TRUE for any of them, or if scalar_expression returns NULL`.\n\nExamples\n--------\n\nCREATE TABLE sq1 (num1 TINYINT);\nCREATE TABLE sq2 (num2 TINYINT);\nINSERT INTO sq1 VALUES(100);\nINSERT INTO sq2 VALUES(40),(50),(120);\n\nURL: https://mariadb.com/docs/server/reference/sql-statements/data-manipulation/selecting-data/joins-subqueries/subqueries/subqueries-and-any