mysql - SQL query for finding a value in multiple ranges -

i have mysql db contains event's date , 3 ranges, i.e from1-to1, from2-to2, from3-to3
each range has different price, i.e from1-to1 rate1 , from2-to2 rate2, ...

so that's 3 columns each range: from, , rate.

i'm trying find query returns rate given month, meaning finds range month in , returns rate of range.

any ideas?
thanks!

it seems data model not normalized. should consider morjas suggestion creating additional table.

below ugly query checks whether date in of 3 ranges, , returns matching rate.

select case          when date '2010-12-05' between range1_from , range1_to range1_rate         when date '2010-12-05' between range2_from , range2_to range2_rate         when date '2010-12-05' between range3_from , range3_to range3_rate        end rate   events  date '2010-12-05' between range1_from , range1_to     or date '2010-12-05' between range2_from , range2_to     or date '2010-12-05' between range3_from , range3_to;