title: MySQL "ANY IN" query?
body: <p>Is there any short way to do something like this in MySQL:</p>
  
  <pre><code>WHERE s.loc1 IN ("A", "B", "C", "D") 
     OR s.loc2 IN ("A", "B", "C", "D") 
     OR s.loc3 IN ("A", "B", "C", "D");
  </code></pre>
  
  <p>without repeating the ("A", "B", "C", "D") bit (and preferably in such a way that this list is still suppliable via @param)? Sadly, the syntax of (s.loc1, s.loc2, s.loc3) IN (blah) only seems to work for AND's instead of OR's.</p>
  
  <p>The ideal solution would look something like:</p>
  
  <pre><code>WHERE (s.loc1, s.loc2, s.loc3) ANY IN ("A", "B", "C", "D");
  </code></pre>