Originally Posted by Old Pedant
Simpler than that:
INSERT IGNORE ...
That's all you need. Don't need the ON DUPLICATE KEY stuff if you just want to ignore the duplication error.
Once again, thank you. Followup question. Is there a way to have the query let me know which records it did not insert due to being duplicates. Not really important, just more curiosity on my part.