MySQL Not regexp Operator

Not regexp is an operator of MySQL. It is used for pattern matching. It compares the given pattern in the column and returns the items which are not matching the patterns.

Syntax

snippet
select name from table_name where column_name not regexp 'pattern';

Example 1

Database:

MySQL Not regexp Operator

Insert:

MySQL Not regexp Operator

Table:

MySQL Not regexp Operator

Query:

MySQL Not regexp Operator
Related Tutorial
Follow Us
https://www.facebook.com/Rookie-Nerd-638990322793530 https://twitter.com/RookieNerdTutor https://plus.google.com/b/117136517396468545840 #
Contents