title: How to bulk SELECT rows with multiple pairs in WHERE clause
body: <p>Let's say I have a table, <code>email_phone_notes</code> that looks like this:</p>
  <pre><code>+-----------------------+--------------+------+-----+---------+-------+
  | Field                 | Type         | Null | Key | Default | Extra |
  +-----------------------+--------------+------+-----+---------+-------+
  | email                 | varchar      | NO   | PRI | NULL    |       |
  | phone                 | varchar      | NO   | PRI | NULL    |       |
  | notes                 | text         | NO   |     | 0       |       |
  +-----------------------+--------------+------+-----+---------+-------+
  </code></pre>
  <p>So, each email/phone combination is unique, but you could have several email addresses with different phone numbers and vice versa. This is a little contrived but it mirrors my scenario.</p>
  <p>I'd like to do a query like this:</p>
  <pre><code>SELECT * FROM email_phone_notes  WHERE email = 'foo@bar.com' AND phone = '555-1212';
  </code></pre>
  <p>But, I'd like to do multiple pairs at once so I don't have to make several <code>SELECT</code> queries. It's also important to keep the pairs together because I don't want to return an errant phone/email combination that wasn't requested.</p>
  <p>I could do something like this, but for the possibility of several hundred values the query will be really long.</p>
  <pre><code>SELECT * FROM email_phone_notes WHERE ( 
    (email='foo@bar.com' &amp;&amp; phone='555-1212') || 
    (email='test@test.com' &amp;&amp; phone='888-1212') || 
     ...
  </code></pre>
  <p>Is there a more elegant solution, or should I stick with this?</p>