لطفا منتظر باشید ...
Bit Operators
The bit operators are not used often. They allow you to work with bit values and perform bit calculations in your queries.
&
value1 & value2
Performs a bitwise AND. This converts the values to binary and compares the bits. Only if both of the corresponding bits are 1 is the resulting bit also 1.For example:
mysql> SELECT 2&1;
+-----+
| 2&1 |
+-----+
| 0 |
+-----+
mysql> SELECT 3&1;
+-----+
| 3&1 |
+-----+
| 1 |
+-----+
|
value1 | value2
Performs a bitwise OR. This converts the values to binary and compares the bits. If either of the corresponding bits are 1, the resulting bit is also 1.For example:
mysql> SELECT 2|1;
+-----+
| 2|1 |
+-----+
| 3 |
+-----+
<<
value1 << value2
Converts value1 to binary and shifts the bits of value1 left by the amount of value2.For example:
mysql> SELECT 2<<1;
+------+
| 2<<1 |
+------+
| 4 |
+------+
>>
value1 >> value2
Converts value1 to binary and shifts the bits of value1 right by the amount of value2.For example:
mysql> SELECT 2>>1;
+------+
| 2>>1 |
+------+
| 1 |
+------+
