database - mysql select between or what? -

i'm learning mysql , have case, have table this:

id, level,        minpost, maxpost  1, 'newbie',           0,      99  2, 'enthusiast',     100,     499  3, 'activist',       500,     749  4, 'socialite',      750,     999 

so how know "level" if have 80 posts?

should use select between or maybe have suggest problem?

ps. cant post image :(

select level <table> <mylevel> between minpost , maxpost 

the between operator following:

expr between min , max 

equals:

(min <= expr , expr <= max)