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

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

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
'^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 '^anonymous[[:digit:]]{3,}$'
LIMIT 0, 30' at line 1

MySQL server version 4.1.22 (yeah, I know it's old :) )

Any help would be greatly appreciated.

--
John C. Nichel IV
System Administrator
KegWorks
http://www.kegworks.com
716.362.9212 x160
j...@kegworks.com

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