Simple query not working

[Tapan]

Hi,

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 ?

Thanks.

[swampBoogie]

You are referring to a table named devbg_products in your order by clause which is not present in the from clause.

[Tapan]

Hi,

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.

Thanks.