I hadn't thought of doing it like that - my application currently reads CSV contents into an array and loops through it - but it's certainly an option; just dump the CSV into a temporary table and use that. Thanks
SELECT listID, email
Originally Posted by da Manual
If you specify the IGNORE keyword in an INSERT statement, errors that occur while executing the statement are treated as warnings instead. For example, without IGNORE, a row that duplicates an existing UNIQUE index or PRIMARY KEY value in the table causes a duplicate-key error and the statement is aborted. With IGNORE, the error is ignored and the row is not inserted.