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






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

1.And Or