~

Invert all bits.

Syntax

MYSQL Copy

SELECT 5 & ~1;
4
SELECT HEX(~X'0000FFFF1111EEEE');
'FFFF0000EEEE1111'

Examples

Example

The result type depends on whether the bit argument is evaluated as a binary string or number:

MYSQL Copy

SELECT 5 & ~1;
4
SELECT HEX(~X'0000FFFF1111EEEE');
'FFFF0000EEEE1111'