Can you use REGEXP with the NOT operator? Give an example.

Using REGEXP with the NOT Operator in MySQL

Yes, in MySQL you can use the NOT operator with REGEXP to find rows where a column does not match a specific regular expression pattern. This is useful for excluding certain patterns from your result set.

Key Points About NOT REGEXP

Syntax: Use column NOT REGEXP 'pattern' in the WHERE clause.
Excludes Matches: Rows where the column matches the regex are excluded from the results.
NULL Behavior: Columns with NULL values are still treated as unknown, so NOT REGEXP also evaluates to NULL for those rows and they are excluded unless handled explicitly.
Combination Example: You can combine NOT REGEXP with IS NULL to include NULLs, e.g., WHERE column NOT REGEXP 'pattern' OR column IS NULL.

Using NOT REGEXP allows more flexible filtering when you need to exclude certain patterns without writing multiple OR conditions.

Example: Exclude Names Starting with 'A' or 'B'

Example: Exclude NULLs and Names Starting with 'A' or 'B'

Question Loading...

Functions and Operators

Keys

Joins