> 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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql
