select from a range

[frans-jan]

Hi,

I need to get colums from a MySQL table
with a query where the result may be in a range.

Imagine cell 'nr' is 12, Now I want the column where this cell is in, as an answer when I ask a query "nr is somwhere between 10 and 15"

How do I build a query like that?

I do know how to do it in PHP after I get the results, but I think that a smart query will be way faster,

Thank you.

[[deleted]]

Manuals are your friends, read them.

http://www.mysql.com/doc/C/o/Comparison_Operators.html