How to Formulate SQL Query from List in Excel?
Posted on 2014-01-31
I've got a list of 100 email addresses.
Need to query against the User table in MySQL, and return their records.
For single query, it's simple.
WHERE `mail` LIKE 'email@example.com'
LIMIT 0 , 30
Then I'm printing to PDF for reporting.
How can I expedite this with a hundred emails, than just kick out a single PDF with all hundred records?
My list is in a single column in an Excel file.