bitwise XOR (^)

Combines two integers to produce a third integer whose binary bits are 1 if either bit in the input numbers are different, ie a 1 in the first number and a 0 in the second, or vice versa.

Syntax

19 = 10011
21 = 10101
^ -----------
6 = 00110
~num

Return Type

Integer

Examples

SELECT 19 ^ 21, bin(19), bin(21), bin(19 ^ 21);
+---------+---------+---------+--------------+
| 19 ^ 21 | bin(19) | bin(21) | bin(19 ^ 21) |
+---------+---------+---------+--------------+
|       6 | 10011   | 10101   | 110          |
+---------+---------+---------+--------------+

Last modified: February 24, 2023

Was this article helpful?