title: MySQL WHERE <multiple-column> IN <subquery>
body: <p>Is there a way (without JOIN) to use the <code>WHERE</code> clause on 2 columns (OR) <code>IN</code> a subquery?
  Currently, I'm doing</p>
  
  <pre><code>WHERE 'col1' IN
  (
      SELECT id FROM table
  ) OR 'col2' IN
  (
      SELECT id FROM table
  )
  </code></pre>
  
  <p>And I'm sure I can do better :) . i've also tried <code>WHERE ('col1', 'col2') IN &lt;subquery&gt;</code> but MySQL says: <code>Operand should contain 2 column(s)</code></p>
  
  <p>Thanks for your help.</p>
  
  <p>Edit: By "No join", I mean I'm alreeady making many joins: <a href="http://pastebin.com/bRfD21W9" rel="noreferrer">http://pastebin.com/bRfD21W9</a>, and as you can see, the subqueries are on another table.</p>