1 Reply Latest reply on Jan 17, 2020 4:42 PM by swaroop.gantela

    How to write the regex equivalent "AND"

    Jet Bonilla

      I want to ssearch something like this:


      REGEXP_MATCH(lower[text field] 'table|chair|stool) AND (broken|defective')


      Well theAND doesn't work, of course.  How do you do this?  It should find any text field that has table, chairs, OR stool AND ALSO either broken or defective (in any order).  REGEXP is super confusing to me. 


      Also, wondering if "table" will also catch the plural "tables" or do I have to spell that out?


      Thank you!