MySQL Tutorial/Math Numeric Functions/BIT XOR

BIT_XOR(expr)

Returns the bitwise XOR of all bits in expr.

This function returns 0 if there were no matching rows.

mysql>
mysql>
mysql> select BIT_XOR(1);
+------------+
| BIT_XOR(1) |
+------------+
|          1 |
+------------+
1 row in set (0.00 sec)