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

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 (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!

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql