NOT_REGEXP Query Help

2012-10-01 Thread John Nichel
Hi all, 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

Re: NOT_REGEXP Query Help

2012-10-01 Thread Rik Wasmus
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

RE: NOT_REGEXP Query Help

2012-10-01 Thread John Nichel
-Original Message- From: Rik Wasmus [mailto:r...@grib.nl] Sent: Monday, October 01, 2012 10:44 AM To: mysql@lists.mysql.com 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