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.
It's REGEXP what you are looking for: ... WHERE prod_desc REGEXP '^[cpa]'
That was it!......Appreciated and thanked!
|All times are GMT +1. The time now is 01:49 PM.|
Powered by vBulletin®
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.