How to use the matches for multiple
is the below one valid?
for each item where id matches (*abc*,*dde*,*ddee*)
for each item where item.id matches "*abc*" or
item.id matches "*dde* or
item.id matches "*ddee*" no-lock:
Keep in mind that using matches will read every record in the item table and not use an index to filter the results.