Find value between two data range in MySql

I ha开发者_Go百科ve a table with three fields id,minvalue and maxvalue.These fields carries multiple values like...

id Minvalue  maxvalue
 1  100        200
 2  201        300
 3  301        400

...and so on. If I supply 250 as input, how can I retrieve its corresponding id using mysql query?

Thanks

This should work:

SELECT * FROM table WHERE 250 BETWEEN maxvalue AND minvalue

SELECT Id FROM table WHERE 250 BETWEEN MinValue AND MaxValue