title: MySQL IN() for two value/array?
body: <p>I'm having trouble finding a better way to search MySQL for a pair of values in a table. I have the value pairs in an array, and would like to duplicate the IN() function, but for more than 1 value.</p>
  
  <p>For example purposed; I have the following 3 pairs:</p>
  
  <pre><code>foo,1
  boo,2
  goo,3
  </code></pre>
  
  <p>The current solution puts me at:</p>
  
  <pre><code>SELECT * FROM [table] WHERE 
  (column1 = 'foo' AND column2 = 1) OR
  (column1 = 'boo' AND column2 = 2) OR
  (column1 = 'goo' AND column2 = 3);
  </code></pre>
  
  <p>I'd like to think there's a more "sexy" solution seeing that I could have as many as a hundred pairs and having that may ORs kind of makes me nauseous.  Thanks!!!</p>