sql 位运算查询

SELECT * FROM `cl_blank_user` where state&2=state;

 

js

var arr=[1,2,4,8,16,32]

for(var i=0;i<arr.length;i++){
   if((arr[i]&3)==arr[i]){
      console.log("包含")
   }
}