Oracle REGEXP_LIKE and word boundaries

by

I believe you want to try

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

because the \b does not appear on this list: Perl-influenced Extensions in Oracle Regular Expressions

The \s makes sure that test starts and ends in a whitespace. This is not sufficient, however, since the string test could also appear at the very start or end of the string being matched. Therefore, I use the alternative (indicated by the |) ^ for start of string and $ for end of string.

Update (after 3 years+)…
As it happens, I needed this functionality today, and it appears to me, that even better a regular expression is (^|\s|\W)test($|\s|\W) (The missing \b regular expression special character in Oracle).

More Related Contents:

  1. Regex match entire words only
  2. What is a word boundary in regex?
  3. Oracle 11g get all matched occurrences by a regular expression
  4. PostgreSQL Regex Word Boundaries?
  5. How to match the first word after an expression with regex?
  6. Finding and removing Non-ASCII characters from an Oracle Varchar2
  7. Phone number regular expressions exact format
  8. Greedy vs. Reluctant vs. Possessive Qualifiers
  9. RegEx: Grabbing values between quotation marks
  10. Regular Expression to match valid dates
  11. In regex, match either the end of the string or a specific character
  12. How to match numbers between X and Y with regexp?
  13. Regex for Comma delimited list
  14. Does a dot have to be escaped in a character class (square brackets) of a regular expression?
  15. What’s the regular expression that matches a square bracket?
  16. How does the regular expression ‘(?
  17. Regex AND operator
  18. How to match all text between two strings multiline
  19. Regex for alphanumeric, but at least one letter
  20. Microsoft office Access `LIKE` VS `RegEx`
  21. Unix grep regex containing ‘x’ but not containing ‘y’
  22. What regular expression can never match?
  23. Regular Expression Validation For Indian Phone Number and Mobile number
  24. php regex word boundary matching in utf-8
  25. How can I parse quoted CSV in Perl with a regex?
  26. htaccess force https and redirect www to non-www, but no other subdomains
  27. Checking for diacritics with a regular expression
  28. Filtering a diff with a regular expression
  29. Javascript – regex – word boundary (\b) issue
  30. Extracting text after last period in string [duplicate]

Leave a Comment