mysql> SELECT levelname FROM level WHERE 24 BETWEEN levelmin AND levelmin + '10'; +-----------+ | levelname | +-----------+ | mittel | +-----------+ 1 row in set (0.00 sec)