56,675
社区成员
发帖
与我相关
我的任务
分享
mysql> select hex(zk^0x203833C048404440FBF8104010E0FCE09550595052483C40C0400000)
from hanzhiku where zk=0x203833C048404440FBF8104010E0FCE09550595052483C40C04000
00;
+--------------------------------------------------------------------+
| hex(zk^0x203833C048404440FBF8104010E0FCE09550595052483C40C0400000) |
+--------------------------------------------------------------------+
| 52483C40C0400053 |
+--------------------------------------------------------------------+
1 row in set, 1 warning (0.01 sec)
mysql>
mysql> select id,hex(zk) from hanzhiku order by length(replace(BIN(zk^'0x7FF0020002003FF002000200FFF8040004000840082011F03E100000'),'0','')) desc limit 1;
+-------+----------------------------------------------------------+
| id | hex(zk) |
+-------+----------------------------------------------------------+
| 17648 | 203833C048404440FBF8104010E0FCE09550595052483C40C0400000 |
+-------+----------------------------------------------------------+
1 row in set, 44606 warnings (0.30 sec)