I would like to search the entire record for a list of text strings using the IN function.
At the moment, I have a search that looks a bit like
(a OR b OR c) AND message_type=foo
which finds za , zb , zc etc. in the field video_type
I would rather use something like
video_type IN (a, b, c) AND message_type=foo
or
_raw IN (a, b, c) AND message_type=foo
Because I want to use the search in a dashboard and have users paste a , b , and c in an input.
But free text search doesn't work if you specify a field to search in — it only seems to find exact matches.
... View more