A question about news headlines order in MySQL

Databases
1

Hello
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
other…

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

Example:

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

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

Can i do it via MySQL with one query?

2

ORDER BY FIELD(source, ‘CNN’, ‘BBC’, ‘CNBC’)

3

Does not work!!

ORDER BY FIELD(source, 1, 3)  LIMIT
4

what comes after LIMIT ?

5

Sorry
It’s working
But how can i get just 5 record from each source and sort them successively

example:

LIMIT 5 from CNN
LIMIT 5 from BBC
LIMIT 5 from CNBC
(then repeat the same)
LIMIT 5 from CNN
LIMIT 5 from BBC
LIMIT 5 from CNBC
etc…

6

that “repeat the same” business cannot be done with sql

why not pull in the last 50 or so, regardless of source, and then play with them in your application code?