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 | +---------+---------+---------+--------------+