How to write a SQL query to find the range from column values?
As follows (replace yourtable and each of the two instances of rangefield):

SELECT *
FROM `yourtable`
WHERE ? BETWEEN CAST(`rangefield` AS int) AND CAST(MID(`rangefield`, LOCATE('-', `rangefield`)+1) AS int);