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 > > someon

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 > '^ano

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 '^anonym