BIT_XOR Function

Description

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.

Syntax

BIT_XOR(expr)

Example

SELECT 1^2^3, BIT_XOR(id) FROM bit_tbl WHERE id in(1,3,5);

                 1^3^5           bit_xor(id)

============================================

                     7                     7