CODEWITHSUNDEEP
mysqlsql-order-by
TilalHusain
TilalHusain

Reputation: 1016

Sorting Comments by priority

I am developing a mysql based commenting system in which I have to sort the comments by Popular, Newest and oldest, I have the newest and oldest working properly but I am having trouble in sorting the comments by Popularity. I have a comments table in my database which stores the comment_date, comments_votes and comment_text, in popular I want to first sort the comments by votes, and for the comments which don't have any votes I want to sort them by date.

For Example If I have

 id   |   Date   |   Comment   | Votes
 1    | 24 March |    Hello    |  0
 2    | 23 March |    WORLD    |  1
 3    | 25 March |    Hello    |  0
 4    | 26 March |    Hello    |  2

I want it to sort so that the result is returned in this order 4, 2, 3, 1.

Upvotes: 1

Views: 72

Answers (3)

ASNAOUI Ayoub
ASNAOUI Ayoub

Reputation: 472

SELECT id
       ,Date
       ,Comment
       ,Votes
ORDER BY Votes DESC

Upvotes: 0

Prafful Garg
Prafful Garg

Reputation: 214

Please try this..

SELECT * FROM TABLE
ORDER BY Votes DESC, DATE DESC

This should work..

Upvotes: 0

M Khalid Junaid
M Khalid Junaid

Reputation: 64496

You can first sort by Votes DESC and then Date DESC

select * from Table1
ORDER BY Votes DESC ,`Date` DESC

Fiddle Demo

Upvotes: 2

Related Questions