in reply to How to Split on specific occurrence of a comma

IMHO - instead of adding the complexity of batching with artificial limits, my proposal is:

use a temporary table to store the list of things you are looking for.
Then let the DB do the work of intersecting the 2 tables.

This is no longer subject to memory or list-size limits, and is likely better optimized by the db engine.

                "Imaginary friends are a sign of a mental disorder if they cause distress, including antisocial behavior. Religion frequently meets that description"