MYSQL LIKE and more than one beginning letter

[mikemacx]

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!

[zergi]

It's REGEXP what you are looking for: ... WHERE prod_desc REGEXP '^[cpa]'

[mikemacx]

That was it!......Appreciated and thanked!