I’d like to run a query that uses this regular expression:
/[^a-zA-Z-. ',]+/
select w from a where w REGEXP ‘/[^a-zA-Z-. ',]+/’
but get this error?
invalid character range
| [B]iberkner wrote on Thu, 04 November 2010 21:02[/B] |
|
I'd like to run a query that uses this regular expression:
/[^a-zA-Z-. ',]+/ select w from a where w REGEXP ‘/[^a-zA-Z-. ',]+/’ but get this error? invalid character range |
A subtraction sign in that context says a range e.g a-z, A-Z, 0-9 etc.
But you have a subtraction sign between Z and . and I’m guessing that is the problem since that is a range that doesn’t make sense.
That’s what it was. Thanks