List:General Discussion« Previous MessageNext Message »
From:Rik Wasmus Date:October 1 2012 2:43pm
Subject:Re: NOT_REGEXP Query Help
View as plain text  
>   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
Thread
NOT_REGEXP Query HelpJohn Nichel1 Oct
  • Re: NOT_REGEXP Query HelpRik Wasmus1 Oct
    • RE: NOT_REGEXP Query HelpJohn Nichel1 Oct