how to group MySql rows based on month?
- by understack
I've a table with a datetime (format: 'Y-m-d H:i:s') 'created' field and 'amount' (integer) field in each row. Now I want to find out total 'amount' in last year month wise. How can I do this?
EDIT
I made an edit to clarify the actual problem.