title: Select rows where (field1, field2, field3) in set (val11,val21,val31),...,(val11,val21,val31)
body: <p>I'm using mysql. I need to select rows from table (with fields <code>id,field1,field2,field3</code>) where <code>(field1,field2,field3)</code> in set of vectors <code>(v11,v21,v31),(v12,v22,v32),...,(v1N,v2N,v3N)</code>. Is it possible to do it with one query? If yes, what fields do I need to index to speed up the query? And is this query faster/slower then <code>N</code> serial simple select queries?</p>
  
  <p>Thank you in advance!</p>