in reply to How to Split on specific occurrence of a comma
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"