When a subquery is used with EXISTS or NOT EXISTS operator, a subquery returns a Boolean value of TRUE or FALSE . The subquery acts as an existence check.
MySQL subquery with EXISTS and NOT EXISTSWhen a subquery is used with EXISTS or NOT EXISTS operator, a subquery returns a Boolean value of TRUE or FALSE . The subquery acts as an existence check.