Compare field/data with many records
what is the best way to compare a variable to all records of one table.
for example variable $url contains www.spam.com and my blacklist table contains a few records also "spam", in this case a true will tell my script to ignore it.
So far i use
PatternCount($URL ; tbl_blackelist::blacklist)
But this only returns the result of the first record.