I'm trying to run a query to search for text within multiple labels, but if the text does not exist in one of the labels I want nothing to return.
Using: label IN (label1, label2) AND text ~ help, is not what I need as that works as an OR clause.
I need it to be a 'AND' clause but can't seem to figure out how to do that. I tried:
label= exampleLabel1 AND label=exampleLabel2 AND text ~ help, but this does not appear to work.
Is there way to do this?
Thanks!