Простой ответ на простой вопрос.

WHERE value BETWEEN 1 AND 10

или

WHERE field >= 1  AND field <= 10