Announcement

Announcement Module
Collapse
No announcement yet.

regular expression syntax

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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

  • #2
    iberkner wrote on Thu, 04 November 2010 21:02

    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.

    Comment


    • #3
      That's what it was. Thanks

      Comment

      Working...
      X