MYSQL LIKE and more than one beginning letter
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.