Mega Code Archive

 

Categories / MySQL / Function

 

Uses the bitwise XOR (^) operator to manipulate the bit values

mysql> mysql> mysql> SELECT 8 ^ 8, 8 ^ 10, 8 ^ 16; +-------+--------+--------+ | 8 ^ 8 | 8 ^ 10 | 8 ^ 16 | +-------+--------+--------+ |     0 |      2 |     24 | +-------+--------+--------+ 1 row in set (0.00 sec) mysql>