title: MySQL bitwise operations, bloom filter
body: <p>I'd like to implement a <a href="http://en.wikipedia.org/wiki/Bloom_filter" rel="noreferrer">bloom filter</a> using MySQL (other a suggested alternative).</p>
  
  <p>The problem is as follows:</p>
  
  <p>Suppose I have a table that stores 8 bit integers, with these following values:</p>
  
  <pre><code>1: 10011010
  2: 00110101
  3: 10010100
  4: 00100110
  5: 00111011
  6: 01101010
  </code></pre>
  
  <p>I'd like to find all results that are bitwise AND to this:</p>
  
  <pre><code>00011000
  </code></pre>
  
  <p>The results should be rows 1 and 5.</p>
  
  <p>However, in my problem, they aren't 8 bit integers, but rather n-bit integers.  How do I store this, and how do I query?  Speed is key.</p>