Return the offset of the last character in the third match that contains a lowercase o, starting at the third character in the subject, with case-insensitive matching: SELECT body, REGEXP_INSTR(body, '\\b\\S*o\\S*\\b', 3, 3, 1, 'i') AS result FROM message; +---+---+ |...
Case-sensitive matching i Case-insensitive matching m Multi-line mode e Extract submatches s POSIX wildcard character . matches \n Default: c For more details, see Specifying the parameters for the regular expression.Returns Returns a value of type VARCHAR. If no matches are found, returns the...
Case-insensitive matching m Multi-line mode e Extract submatches s POSIX wildcard character . matches \n Default: c For more details, see Specifying the parameters for the regular expression.Returns Returns a value of type NUMBER. Returns NULL if any argument is NULL.Usage...
Run a case-sensitive query with a wildcard: SELECT * FROM cities WHERE REGEXP_LIKE(city, 'san.*'); +---+ | CITY | |---| +---+ Run a case-insensitive query with a wildcard: SELECT * FROM cities WHERE REGEXP_LIKE(city, 'san.*', 'i'); +---+ | CITY | |---| |...
The following example performs a case-insensitive match and returns the part of the string that matches the first group (ie): SELECT REGEXP_SUBSTR_ALL('a1_a2a3_a4A5a6', '(a)([[:digit:]])', 1, 1, 'ie') AS matches; +---+ | MATCHES | |---| | [ | | "a", | | "a"...
Return the third match that contains a lowercase o, starting at the third character in the subject, with case-insensitive matching: SELECT body, REGEXP_SUBSTR(body, '\\b\\S*o\\S*\\b', 3, 3, 'i') AS result FROM message; +---+---+ | BODY | RESULT | |---+---| | Hello...