mysql select min price value exclude zero
<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>