Use the bitwise AND (&) operator to manipulate the bit values. : AND « Function « SQL / MySQL

1. SQL / MySQL
2. Function
3. AND

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>

   
    
    
  

Related examples in the same category