[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!