regular expression syntax

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

The subtraction sign _after_ the Z is probably your problem.

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