how to soft MySQL data in Month?

admin

Administrator
Staff member
In MySQL data in date is yyyy-mm-dd,
I need to soft the data in month,
like soft the data in January...etc.
how to use MySQL command?
I try it like this:
mysql_query("select * from data where date='2000-01'");

But failed:(

who can help me?
 
Back
Top