Select mysql query between date?

date, mysql, select

Solution

select * from *table_name* where *datetime_column* between '01/01/2009' and curdate()

or using `>=` and `<=` :

select * from *table_name* where *datetime_column* >= '01/01/2009' and *datetime_column* <= curdate()

Problem

How to select data from mysql table past date to current date? For example, Select data from 1 january 2009 until current date ?? My column "datetime" is in datetime date type. Please help, thanks Edit: If let say i want to get day per day data from 1 january 2009, how to write the query? Use count and between function?

Original source