Mega Code Archive

 

Categories / MySQL / Function

 

Use the bitwise AND (&) operator to manipulate the bit values

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