Write a query to find to the date between date A and date B

Question

Please give me the idea using mysql query.

Answer 1

SELECT columns FROM table WHERE date_field BETWEEN '2010-01-05' AND '2010-02-05'

Also look up on DATE_ADD and DATE_SUB for basing on intervals:

http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html