View Full Version : MYSQL LIKE and more than one beginning letter

01-27-2013, 02:25 AM
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.


01-27-2013, 04:11 PM
It's REGEXP what you are looking for: ... WHERE prod_desc REGEXP '^[cpa]'

01-27-2013, 08:12 PM
That was it!......Appreciated and thanked!