title: 1 table, but two tables. Something like disk partitioning for mysql tables
body: <p>Is there a way to have one table that is split in two, or partitioned like a hard drive, so that I can call </p>
  
  <pre><code>SELECT * FROM email validated
  </code></pre>
  
  <p>or</p>
  
  <pre><code>SELECT * FROM email pending
  </code></pre>
  
  <p>and get two different results. Both results not containing the other's rows. </p>
  
  <p>is this something. I feel like I read about mysql partitioning somewhere, a long time ago, and I was wondering if that is what this is. If not, is this possible.</p>