php - 我如何使用 mysql 找出本月的订单明智礼帽

Question

name     amount  date
----------------------------------------------------
sarava   10000     2015-12-01
muthu    5000     2016-01-08
sarava   7000     2016-01-06
muthu    10000    2016-01-16

本月预计输出高度顺序: name->muthu<br/>
amount->15000

Answer 1

尝试如下:

SELECT name, SUM( amount ),date_format( `date` , '%M' ) as month
FROM tablename
where month='January'
GROUP BY date_format( `created_at` , '%M' )