Mysql NOT REGEXP
From w3cyberlearnings
Contents |
MySQL NOT REGEXP Function
This function is a negative of REGEXP() function.
Syntax NOT REGEXP
- expre word or string
- pat is a regular expression pattern matching.
expre NOT REGEXP pat;
Example 1
mysql> SELECT 'good leader' NOT REGEXP '^good .*r$'; +---------------------------------------+ | 'good leader' NOT REGEXP '^good .*r$' | +---------------------------------------+ | 0 | +---------------------------------------+ 1 row in set (0.00 sec)
