I have a MySQL table contains news headlines from many sources like:

  • BBC
  • CNN
  • CNBC
  • Other...

Table structure:
id = article ID
source = like: CNN
title = news headline
sentTime = article time

My question is:
How can i order the headlines by news sources and recently added headlines.


Article 1 -> CNN -> 1 hour ago
Article 2 -> BBC -> 2 hour ago
Article 3 -> CNBC -> 3 hour ago

I want to order the result by the source then by the time.

Can i do it via MySQL with one query?