Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
  1. #1
    New Coder
    Join Date
    Feb 2009
    Location
    Los Angeles
    Posts
    41
    Thanks
    2
    Thanked 1 Time in 1 Post

    MYSQL LIKE and more than one beginning letter

    Hi all......

    Can't seem to find the answer anywhere, so I thought you might know. When using LIKE, how do I search for records where the column values begin with MULTIPLE letters, such as A, R, and T.

    I know in SQL it's SELECT * from products_tbl WHERE prod_desc LIKE '[cpa]%'

    But I don't know how to do this in MYSQL....the above query returns an empty set when I know the letters are there.

    Thanks!

  • #2
    New to the CF scene
    Join Date
    Nov 2012
    Posts
    9
    Thanks
    1
    Thanked 2 Times in 2 Posts
    It's REGEXP what you are looking for: ... WHERE prod_desc REGEXP '^[cpa]'

  • Users who have thanked zergi for this post:

    mikemacx (01-27-2013)

  • #3
    New Coder
    Join Date
    Feb 2009
    Location
    Los Angeles
    Posts
    41
    Thanks
    2
    Thanked 1 Time in 1 Post
    That was it!......Appreciated and thanked!


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •