Select query with a number range in Mysql

Question

I have a user table like this:

User (id, name, rank)

I want to check user's rank and get the corresponding text (ex: if user's rank in between 1-10, I can get the text "User in top 10!")

I created a rank_text table like this:

rank_text(id, rank_from, rank_to, text)
         (1,  1,         10,      "You are in top 10!")

How I can query this case?

Can you give me a advise?

Thank you very much!

Gordon Linoff · Accepted Answer · 2019-08-01 02:48:37Z

5

You can use a join:

select u.*, rt.text
from users u left join
     rank_text rt
     on u.rank between rt.rank_from and rt.rank_to;

answered Aug 1, 2019 at 2:48

Gordon Linoff

1.3m62 gold badges705 silver badges857 bronze badges

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

1 Answer 1