MySQL ANY Operator

The ANY keyword is a MySQL operator that returns the Boolean value TRUE if the comparison is TRUE for ANY of the subquery condition. In other words, this keyword returns true if any of the subquery condition is fulfilled when the SQL query is executed.

The ANY keyword must follow the comparison operator. It is noted that ALL SQL operator works related to ANY operator, but it returns true when all the subquery values are satisfied by the condition in MySQL.

The ANY operator works like comparing the value of a table to each value in the result set provided by the subquery condition. And then, if it finds any value that matches at least one value/row of the subquery, it returns the TRUE result.

Syntax:

operand comparison_operator ANY (subquery)       

Where comparison operators can be one of the following:

    =  >  <  >=  <=  <>  !=  

Let's move on to use of EXISTS in MySQL

Share this page on :

FaceBook Whatsapp Twitter