How to select from a span if one end can be 0?

Question

MySQL

For example, I send a circulation value of 1000 to the request.
The table looks like this
Start End Price
10 100 500
101 500 1000
501 600 1500
601 0 2000
How do I choose the price in this case, BETWEEN is not suitable, because there should be two ends.
Only >= and <=.

SELECT price FROM prices WHERE tirag >= start AND tirag <= end

Answer 1

WHERE `start` <= `price` AND (`end` = 0 OR `price` <= `end`)