NOT REGEXP

Returns 1 if the string expr doesn't match the regular expression specified by the pattern pat, 0 otherwise.

Syntax

<expr> NOT REGEXP <pattern>

Examples

SELECT 'datalake' NOT REGEXP 'd*';
+------------------------------+
| ('datalake' not regexp 'd*') |
+------------------------------+
|                            0 |
+------------------------------+