I want to group and list them in MYSQL.

Asked 5 months ago, Updated 5 months ago, 12 views

I have a preliminary MYSQL question, but I would like to group them in title when there is a table like the one below and list them in order of new date.
Could you tell me the SELECT statement at this time?
Thank you for your cooperation.

id title date
1AAAA June 20, 2017
2BBBBBB June 19, 2017
3AAAA June 18, 2017
4CCCCCC June 17, 2017
5BBBBBB June 20, 2017