Find value between two data range in MySql

Question

I have 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

Pekka · Accepted Answer · 2010-07-17 11:06:22Z

7

This should work:

SELECT * FROM table WHERE 250 BETWEEN maxvalue AND minvalue

answered Jul 17, 2010 at 11:06

Pekka

451k150 gold badges989 silver badges1.1k bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Chris Diver · Accepted Answer · 2010-07-17 11:06:47Z

2

SELECT Id FROM table WHERE 250 BETWEEN MinValue AND MaxValue

answered Jul 17, 2010 at 11:06

Chris Diver

19.9k4 gold badges50 silver badges58 bronze badges