bitwise NOT (~)
Inverts all of the bits of a given number.
This operator is unary, ie, it applies to only one argument.
Syntax
~num
Return Type
Integer
Examples
SELECT ~8, bin(8), bin(~8); **** +----------------------+--------+------------------------------------------------------------------+ | ~8 | bin(8) | bin(~8) | +----------------------+--------+------------------------------------------------------------------+ | 18446744073709551607 | 1000 | 1111111111111111111111111111111111111111111111111111111111110111 | +----------------------+--------+------------------------------------------------------------------+