[NOT] REGEXP_LIKE
Purpose
This predicate states whether a string matches a regular expression.
Syntax
Usage notes
- For detailed information and examples for regular expressions, see Regular expressions.
- See also SUBSTR[ING], REGEXP_INSTR, REGEXP_SUBSTR, and REGEXP_REPLACE.
Example:
SELECT 'My mail address is my_mail@exasol.com'
REGEXP_LIKE '(?i).*[a-z0-9._%+-]+@[a-z0-9.-]+\.[a-z]{2,4}.*'
AS contains_email;