# Problem with WHERE in MySql PHP

**URL:** <https://forum.kirupa.com/t/problem-with-where-in-mysql-php/200394>\
**Category:** programming\
**Created:** [September 11, 2006, 10:07pm UTC](https://forum.kirupa.com/t/problem-with-where-in-mysql-php/200394 "2006-09-11T22:07:24Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![sigepmest37](https://avatars.discourse-cdn.com/v4/letter/s/8491ac/32.png) [@sigepmest37](https://forum.kirupa.com/u/sigepmest37)\
**Post date:** [September 11, 2006, 10:07pm UTC](https://forum.kirupa.com/t/problem-with-where-in-mysql-php/200394/1 "2006-09-11T22:07:24Z")

</div>

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:

```php

$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!