[mysql] & 연산자 활용

mysql 에서 제공 된다니.. 놀랍습니다..
활용하면 끝도 없는 Query...

mysql> select num from my_table;
+-----+
| num |
+-----+
|   1 | 
|   2 | 
|   3 | 
|   4 | 
|   5 | 
|   6 | 
|   7 | 
|   8 | 
|   9 | 
|  10 | 
|  11 | 
+-----+
11 rows in set (0.00 sec)
mysql> select num from my_table where num & 2;  --> 10 (2진수)
+-----+
| num |
+-----+
|   2 |  -->   10
|   3 |  -->   11
|   6 |  -->  110
|   7 |  -->  111
|  10 |  --> 1010
|  11 |  --> 1011
+-----+
6 rows in set (0.00 sec)
mysql> select num from my_table where num & 3; --> 11 (2진수)
+-----+
| num |
+-----+
|   1 |  -->    1
|   2 |  -->   10 
|   3 |  -->   11 
|   5 |  -->  101 
|   6 |  -->  110 
|   7 |  -->  111 
|   9 |  --> 1001 
|  10 |  --> 1010 
|  11 |  --> 1011 
+-----+
9 rows in set (0.00 sec)
mysql> select num from my_table where num & 4; --> 100 (2진수)
+-----+
| num |
+-----+
|   4 |  -->   100 
|   5 |  -->   101
|   6 |  -->   110 
|   7 |  -->   111 
+-----+
4 rows in set (0.00 sec)