title: In MySQL How do I specify Collation for WHERE-IN clause?
body: <p>In MySQL, I can specify the collation if I have a standard WHERE clause like this:</p>
  
  <pre><code>SELECT * FROM myTable WHERE email_address = 'foo@bar.com' COLLATE utf8_general_ci;
  </code></pre>
  
  <p>However the following fails if I have multiple email addresses in a WHERE-IN clause</p>
  
  <pre><code>SELECT * FROM myTable WHERE email_address IN ('foo@bar.com', 'test@test.com') COLLATE utf8_general_ci;
  </code></pre>
  
  <p>What am I missing to get this to work?  Mysql 5.5.</p>
  
  <p>Thanks!</p>