> 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

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.