I have a simple query like this and its not returning the results:
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 ?
You are referring to a table named devbg_products in your order by clause which is not present in the from clause.
Yes sorry that was a typo, but i figured out how to do it. So now i am doing like this:
SELECT * FROM products WHERE ItemName LIKE '%rover%Brake%Pads%' ORDER BY ItemName LIMIT 0, 16
And it seems to be working fine.