#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2013
    Posts
    17
    Rep Power
    0

    How did SELECT 'aXbc' REGEXP '^[a-dXYZ]$'; results in false


    Hi with reference to
    [mysql 5.5 documentation]/regexp.html, sorry I'm a new account so can't post link
    mysql> SELECT 'aXbc' REGEXP '^[a-dXYZ]$'; -> 0
    I still do not understand why the result is false.

    I mean REGEXP '^[a-dXYZ]$'

    means front bank and end the pattern must be in a,b,c,d, X,Y Z set, am I right?

    am I getting things wrong?

    thanks
  2. #2
  3. --
    Devshed Expert (3500 - 3999 posts)

    Join Date
    Jul 2012
    Posts
    3,910
    Rep Power
    1045
    Hi,

    the regex you've written down matches a string consisting of a single character of the list a, b, c, d, X, Y, Z..

    If you want a string starting with a character of this list, followed by an arbitrary number of characters and ending with a character of this list, you need:

    Code:
    ^[a-dXYZ].*[a-dXYZ]$

    Comments on this post

    • mysqlnoob1 agrees : I have try out and yes your answer is correct!

IMN logo majestic logo threadwatch logo seochat tools logo