The IN, SUBSET and INTERSECT operators can be used
for set-like searches on multi-value type fields such as
strlst
. For example, to find rows where a query term is
present in a strlst column, use IN. To find rows where a
strlst
column contains any of a list of query terms, use
INTERSECT to find the set intersection of the row and the query
set. To find rows where all query terms must be present in the
row, use SUBSET.