AnsweredAssumed Answered

Compare field/data with many records

Question asked by firebase on Aug 9, 2014
Latest reply on Aug 10, 2014 by philmodjunk

Title

Compare field/data with many records

Post

     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.

Outcomes