按季度调用mySQL的一组结果的最佳方法是什么？

Question

I am looking to order a set of results of a mySQL data by quarter. They have data fields, so I am wondering if I should be doing this in PHP or in the query itself?

Answer 1

if you have date field in the db use it to group with it,

like:

group by QUARTER(date)

of course if you want to take in account the years also

use

group by YEAR(date) , QUARTER(date)