CODEWITHSUNDEEP
mysqlselect
Seehyung Lee
Seehyung Lee

Reputation: 610

How to find a range of given number?

I have a table like below and I want to find the range of inputted number. ex) if users enters 84, MySql query returns B. 

Rank  Range_Start Range_End
A       90          100
B       80          89
C       70          79
.
.
H
I        0          10

Upvotes: 0

Views: 44

Answers (1)

Sylvain Leroux
Sylvain Leroux

Reputation: 51990

What about:

SELECT Rank FROM tbl WHERE Range_Start < my_value AND Range_End > my_value

Or (if you don't need strict inclusion):

SELECT Rank FROM tbl WHERE my_value BETWEEN Range_Start AND Range_End

Upvotes: 2

Related Questions