Best index type for a numeric range in MySql
===

What storage type (BTREE, RTREE, HASH) is the best for "from" and "to" to get the fastest result from queries like this:

    SELECT `title`, `from`, `to` FROM `table_name`
    WHERE @year >= `from` AND @year <= `to`


@year is the parameter to be replaced with a number 

and

all numbers (@year, from, to) are float.