I need to search in string, more words in any order.
For example, wh need a regex to match both row, using words "search" AND "text"
search in this text
in this text search
With a classic regexp I use this:
(?=.*\bsearch\b)(?=.*\btext\b).*
But regexp_like not support \b.
I know i can use a select with a multiple condition
select * from table
where string like '%search%'
and string like '%text%'
but if there is a solution with regexp_like I prefer.
Regards, Marco
Create an Oracle Text index on your column:
Then you can use:
Which would search the
value
column for words with thesearch
stem (i.e.search
,searches
,searching
), as indicated by the$
prefix on the term, and the exact wordtext
.So, for the sample data:
The query would output:
db<>fiddle here