0

I am using regex to search for exact two words in any order. I got the first part of the search but the second part is not working.

REGEXP_SUBSTR('TWO WORDS ARE ONE','(?:^|\W)WORDS(?:$|\W') - one word search

how do I add one more word in the above search?

Kshitiz Gupta
  • 23
  • 4
  • Why not just use like? `column like '%WORD1%' and column like '%WORD2%'` – Andrew Feb 22 '22 at 16:03
  • Do you need to extract the two strings? Possible duplicate of [regex to match string containing two names in any order](https://stackoverflow.com/questions/4389644/regex-to-match-string-containing-two-names-in-any-order) – Fred Feb 22 '22 at 17:13

0 Answers0