SQL query groups data by month by field (2017-08-15 11:34:05)

about making SQL queries sorted by field me_createtime by month

Use functions: Date_format Group queries by month and sort by month

On the Code

$sql = "Select Date_format (me_createtime, '%y-%m ') as Create_month,count (me_id) as Me_num from {$SETTING [' db '] [' prefix '] }member where Me_state in (the) and sm_id= ' $sm _id ' GROUP by Date_format (Me_createtime, '%y-%m ') Order by Date_format (Me_cre Atetime, '%y-%m ') desc ";

　　

SQL query groups data by month by field (2017-08-15 11:34:05)