From: Rik Wasmus
Date: October 1 2012 2:43pm
Subject: Re: NOT_REGEXP Query Help
List-Archive: http://lists.mysql.com/mysql/228294
Message-Id: <201210011643.42009.rik@grib.nl>
MIME-Version: 1.0
Content-Type: Text/Plain;
  charset="us-ascii"
Content-Transfer-Encoding: 7bit

>   I'm having an issue using regular expressions, and I was hoping someone
> can see the syntax error that I'm missing (Monday morning, not enough
> coffee, etc).  Running the following query returns the error:
> 
> SELECT `a.custid`,`a.login` FROM ol.customers a WHERE `a.login` NOT_REGEXP
> '^anonymous[[:digit:]]{3,}$';
> Error:
> 
> MySQL said
> #1064 - You have an error in your SQL syntax; check the manual that
> corresponds to your MySQL server version for the right syntax to use near
> 'NOT_REGEXP '

It's 
NOT REGEXP
... without the underscore...
-- 
Rik Wasmus