SELECT e.* FROM table_e e WHERE start_value BETWEEN e.start AND e.end OR (start_value <= e.start AND end_value >= e.end);