An aggregate function. It performs XOR operations in bits on every bit of expr. The return value is a BIGINT type. If there is no row that satisfies the expression, NULL is returned.
BIT_XOR(expr)
SELECT 1^2^3, BIT_XOR(id) FROM bit_tbl WHERE id in(1,3,5);
1^3^5 bit_xor(id)
============================================
7 7