Problem with WHERE in MySql PHP

programming
1

It always seems like the easiest part of the code generates the biggest problems.

I am running a search query into a products table. I have all that down just fine. I then decided to also make it so that no products with a price of 0.00 are returned. This is what I came up with:


$query = "SELECT * FROM ds_products WHERE (pName LIKE '%shift%') || (pNum LIKE '%shift%') AND pSalesPrice!='0.00' ORDER BY 'pSalesPrice' ASC LIMIT 0, 12";

It isn’t generating an error, but it IS returning products with the price of 0.00.

What am I doing wrong?

Thanks in advance for the help!