CODE EXAMPLE FOR SQL

plsql regex match whole word

select 1 from dual 
  where regexp_like ('does test work here', '(^|s)test(s|$)');