~

Invert all bits. This unary operator flips every bit in the operand, changing 1s to 0s and 0s to 1s.

Syntax

~

Description

Bitwise NOT. Converts the value to 4 bytes binary and inverts all bits.

Examples

SELECT 3 & ~1;
+--------+
| 3 & ~1 |
+--------+
|      2 |
+--------+

SELECT 5 & ~1;
+--------+
| 5 & ~1 |
+--------+
|      4 |
+--------+

See Also

• Operator Precedence

_{This page is licensed: CC BY-SA / Gnu FDL}