By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
WITH ranges AS (
SELECT 1 AS id, 'ABC' AS title, '0-500' AS `range` UNION ALL
SELECT 2, 'PQR', '501-600' UNION ALL
SELECT 3, 'XYZ', '601-700'
)
SELECT *
FROM ranges
WHERE 0 < SUBSTRING_INDEX(`range`, '-', -1) AND
550 > SUBSTRING_INDEX(`range`, '-', 1);
| id | title | range |
|---|---|---|
| 1 | ABC | 0-500 |
| 2 | PQR | 501-600 |