mysql在两值之间,Mysql：在两列之间选择值

I'm trying to select a value between 2 columns. Here is my dataset

id from to price

1 0.00 2.00 2.50

2 2.00 3.00 3.00

3 3.00 4.00 4.50

My goal, if I have a value of 2 is to select the line with the ID 1 (between from and to). So here is the query I'm using :

select * from table where 2 between from and to;

And here are the results that MySQL returns when executing this query :

id from to price

1 0.00 2.00 2.50

2 2.00 3.00 3.00

And the result I'm looking for is the following :

id from to price

1 0.00 2.00 2.50

I've tried using < and >, etc. But, I'm always getting two results. Any help would be much appreciated.

解决方案

SO, you don't want the lower bound to be inclusive, right?

SET @value = 2;

SELECT * FROM table WHERE from > @value AND @value <= to;