title: SQL where conditions in-list with multiple item?
body: <p>I would like to query a table, where i need 2 columns meet certain criteria, as an example, a table like below:</p>
  
  <pre><code>LastName FirstName Age address
  LN1      FN1        18  ADD1
  LN2      FN1        20  ADD2
  </code></pre>
  
  <p>Now I want to extract 1st address like below:</p>
  
  <pre><code>select * from mytable
  where LastName in 'LN1' and FirstName in 'FN1' 
  </code></pre>
  
  <p>Can I use such a condition:</p>
  
  <pre><code>where (LastName, FirstName) in (LN1,FN1)
  </code></pre>
  
  <p>please kindly help. thanks.</p>