Get date from dates range in MySQL query -

i want dates when have dates range. example: when have 2 dates: 2010-10-05 , 2010-10-10 want get

2010-10-05 2010-10-06 2010-10-07 2010-10-08 2010-10-09 2010-10-10 

have got idea how in mysql query?

as requires loop, need create stored procedure.

there can iterate on days:

declare my_date date; set my_date = my_date + interval 1 day