MySQL display all date in between range

I want to display all dates between a from and to dates from MySQL. For example the data from schedule table that has from and to fields are: from date is 2013-3-13, and to date is 2013-3-20, my desired result is: 2013-3-13 2013-3-14 2013-3-15 2013-3-16 2013-3-17 2013-3-18 2013-3-19 2013-3-20 How can I achieve this using … Read more