^

Syntax

^

Description

Bitwise XOR. Converts the values to binary and compares bits. If one (and only one) of the corresponding bits is 1 is the resulting bit also 1.

Examples

SELECT 1 ^ 1; +-------+ | 1 ^ 1 | +-------+ | 0 | +-------+  SELECT 1 ^ 0; +-------+ | 1 ^ 0 | +-------+ | 1 | +-------+  SELECT 11 ^ 3; +--------+ | 11 ^ 3 | +--------+ | 8 | +--------+

See Also

• Operator Precedence

_{This page is licensed: GPLv2, originally from fill_help_tables.sql}