title: SQL : build a query that reads from a file
body: <p>i have a table with column name,add,no tel. ( millions of rows)
  i need to pull a list of names ( like hundreds) from the table.
  the straight forward way is like this...</p>
  
  <p><code>select * from table where name = name1 or name = name2 .....or name = name300</code></p>
  
  <p>i tried to make it more simpler,
  i import the list of name into another table,say table2.
  then i do a subquery.</p>
  
  <pre><code>select * from table where name like '%'+(select * from table2)+'%'
  </code></pre>
  
  <p>but it did not work.</p>
  
  <p>please help how i can accomplish this efficiently.
  thank u.</p>