Trying to find a way to use regexp_like (in 11gR2) to find whole words, not partial matches, within a string.
For example:
create table regex_test (id int, name varchar2(30));
insert into regex_test values (1, 'John featuring Jane');
insert into regex_test values (2, 'Featuring John and Jane');
insert into regex_test values (3, 'John and Jane');
insert into regex_test values (4, 'John featuring');
insert into regex_test values (5, 'John with Jane');
insert into regex_test values (6, 'John and Jane within intro');
The goal here is to find all names containing the words 'featuring' and 'with'. Case-insenstive. Not matching on 'within'.
We're looking for hits on ids 1, 2, 4 and 5 and have not been able to find a good example out there.
Thanks,
Todd