^

Bitwise XOR.

Syntax

MYSQL Copy

SELECT 1 ^ 1;
0
SELECT 1 ^ 0;
1
SELECT 11 ^ 3;
8
SELECT HEX(_binary X'FEDC' ^ X'1111');
'EFCD'

Examples

Example

The result type depends on whether the arguments are evaluated as binary strings or numbers:

MYSQL Copy

SELECT 1 ^ 1;
0
SELECT 1 ^ 0;
1
SELECT 11 ^ 3;
8
SELECT HEX(_binary X'FEDC' ^ X'1111');
'EFCD'