Important Points About MySQL EXISTS Operator
- Exists Operator works with a parent query and its corresponding subquery.
- Data of parent query is only displayed when subquery return any value.
- This operator return boolean values i.e. either TRUE or FALSE.
- Although it can show some resemblance with IN operator, these two operator has vast difference when it comes to implementation.
- EXISTS query is found efficient when dealing with large datasets.
MySQL EXISTS Operator
MySQL EXISTS operator is a boolean operator that returns true or false depending on the existence of any record in a subquery.
EXISTS operator returns true if the subquery returns one or more than one value.