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?
Read the manual
oder by month(date_field)
You mean soRting, don't you?