In MySQL, XOR is used to check two operands, it returns NULL if either operand is NULL. For non-NULL operands, evaluates to 1 if an odd number of operands is nonzero, otherwise 0 is returned.
To check two operands, it returns NULL if either operand is NULL for non-NULL operands, evaluates to 1 if an odd number of operands is nonzero, otherwise 0 is returned, use the following syntax:
Parameters:
a XOR b: Mathematically equal to (a AND (NOT b)) OR ((NOT a) and b).
XOR
operator to check two operand, both of the operands are true, so it returns FALSE.Note:
In the above example, both of the operands are true, so it returns FALSE
You can use MySQL Command Line Client to check two operands with XOR, it returns NULL if either operand is NULL. It will look like this: