List:General Discussion« Previous MessageNext Message »
From:John Nichel Date:October 1 2012 2:49pm
Subject:RE: NOT_REGEXP Query Help
View as plain text  
> -----Original Message-----
> From: Rik Wasmus [mailto:rik@stripped]
> Sent: Monday, October 01, 2012 10:44 AM
> To: mysql@stripped
> Subject: Re: NOT_REGEXP Query Help
>
> >   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
>

You know, I've been staring at this thing for the better part of an
hour...baffled as to why it isn't working.

New rule: THREE cups of coffee before I start working.

Thanks Rik!
Thread
NOT_REGEXP Query HelpJohn Nichel1 Oct
  • Re: NOT_REGEXP Query HelpRik Wasmus1 Oct
    • RE: NOT_REGEXP Query HelpJohn Nichel1 Oct