Description
The XOR function returns NULL if one of the operands is NULL. It returns 1 if an odd number of operands is nonzero, else 0 is returned.
This function has the form:
SELECT XOR
Parameter | Description |
---|---|
Operands | Numbers |
Return Value
NULL- If one of the operands is NULL.
1- If an odd number of operands is non-zero.
Else 0.
Examples
The following example shows the basic use of this function:
mysql> SELECT 1 XOR 1;
-> 0
mysql> SELECT 1 XOR 0;
-> 1
mysql> SELECT 1 XOR NULL;
-> NULL
mysql> SELECT 1 XOR 1 XOR 1;
-> 1