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