Hi,

I have a simple query like this and its not returning the results:

Code:
SELECT * FROM products WHERE ItemName LIKE '%rover%' AND ItemName LIKE '%Brake%Pads%' ORDER BY devbg_products.ItemName LIMIT 0, 16
Can anyone please help me ?

Thanks.