Pattern matching like Anti-virus software

[jesvh]

Hi , :wave:

Does anybody know how the anti-virus softwares work on
virus pattern matching ?
Can it be implemented by Database functions ?

I have some problems like below :

in DB
Rec 1 = AAA, BBB, CCC ( each is value of a data column )
Rec 2 = NULL, BBB, DDD
Rec 3 = AAA, CCC, DDD
Rec 4 = EEE, BBB, CCC, FFF
...
...


Now , give a sample with values
Sample = NULL, BBB, CCC

I want the result of this query list Rec 1 ,Rec 4 .....
since them include all elements ( or match all conditions ) in sample

I think it is similar to anti-virus software pattern matching
( maybe it isn't .... :sick: )

Or, If it isn't scope of DB, can anybody tell me what to refer to
about this topic.


Thanks !!!