Using Logical XOR operator with NULL value : XOR « Logic Operator « MySQL Tutorial

1. MySQL Tutorial
2. Logic Operator
3. XOR

mysql>
mysql>
mysql> SELECT 1 XOR NULL;
+------------+
| 1 XOR NULL |
+------------+
|       NULL |
+------------+
1 row in set (0.00 sec)

mysql> SELECT NULL XOR NULL;
+---------------+
| NULL XOR NULL |
+---------------+
|          NULL |
+---------------+
1 row in set (0.00 sec)

mysql>
mysql>