Hi All,
I've the following table with five records and I want to search the exact term 'auto' expecting two records to be returned (2, 5 and 6). Is it possible with like operator, instr function or regular expression. I can't use CONTAINS operator (Oracle Text Search) due to some development restrictions.
create table test(
id number,
name varchar2(100));
insert into test values(1,'automation increase efficiency');
insert into test values(2,'Auto');
insert into test values(3,'this record does not contain the search term');
insert into test values(4,'this is an automatic reply');
insert into test values(5,'Auto Renewal');
insert into test values(6,'Turn off auto tune');
Thank you.