[NOT] REGEXP_LIKE

Purpose

This predicate states whether a string matches a regular expression.

Syntax

NOT REGEXP_LIKE

Usage Notes

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;