~
Bitwise NOT. Converts the value to 4 bytes binary and inverts all bits.
SELECT 3 & ~1; +--------+ | 3 & ~1 | +--------+ | 2 | +--------+ SELECT 5 & ~1; +--------+ | 5 & ~1 | +--------+ | 4 | +--------+
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/bitwise-not/