Select mysql query between date?

Question

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?

Answer 1

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

or

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

Answer 2

You can use now() like:

Select data from tablename where datetime >= "01-01-2009 00:00:00" and datetime <= now();