tapan — 2012-03-16T12:39:03-04:00 — #1
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 ?
swampboogie — 2012-03-16T13:16:33-04:00 — #2
You are referring to a table named devbg_products in your order by clause which is not present in the from clause.
tapan — 2012-03-16T13:18:17-04:00 — #3
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.
mittineague — 2014-09-23T19:42:38-04:00 — #4
This topic is now archived. It is frozen and cannot be changed in any way.