On Sunday, November 4, 2018, Mark Williams <
markwillimas@gmail.com> wrote:
I can’t figure out how to search myfield for all instances which contain “text1” AND “text2”.
In other words | is the OR operator. What is the AND operator. Tried + and whilst that executes, it doesn’t return matching fields.
=====================
Myfield ~* ‘text1’ AND myfield ~* ‘text2’
There is no convenient concept of AND in the sense you want it in Regular Expressions and “+” has its own meaning of “one or more of the previous item”.
David J.