XOR

Logical XOR. 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.

Syntax

MYSQL Copy

SELECT 1 XOR 1;
0
SELECT 1 XOR 0;
1
SELECT 1 XOR NULL;
NULL
SELECT 1 XOR 1 XOR 1;
1

Examples

Example

a XOR b is mathematically equal to (a AND (NOT b)) OR ((NOT a) and b).

MYSQL Copy

SELECT 1 XOR 1;
0
SELECT 1 XOR 0;
1
SELECT 1 XOR NULL;
NULL
SELECT 1 XOR 1 XOR 1;
1