How to make a selection in MySQL (minimum value)?

Question

MySQL

Hello! Can you please tell me how to correctly organize the selection of the minimum value from the table?
The conditions are as follows:
The table contains price values ​​0,0,0,0,150,300,2560 You
must select the minimum value that is not equal to 0, and if everything is 0, then 0 accordingly.
I would be grateful for your help.

Answer 1

Try like this:

SELECT MIN(NULLIF(`price`, 0))
FROM `mytable`;