title: mysql select min price value exclude zero
body: <p>I need to fetch the minimum price value and exclude zero values from database. Here is mysql query that is not working:</p>
  
  <pre><code>SELECT MIN(price) AS lowprice FROM price WHERE status = 1 AND price &gt; 1 LIMIT 1
  </code></pre>