CODEWITHSUNDEEP
mysqlsql
Waseem Senjer
Waseem Senjer

Reputation: 1048

Order posts by Last comment date and the created data

I have Posts table with two attributes "last_comment" and "created" and I save the unix time stamp date , I want to order the posts by the created date and also the last_comment Descending .

Upvotes: 0

Views: 316

Answers (4)

Khalid Amin
Khalid Amin

Reputation: 902

SELECT *
  FROM table
 ORDER BY created DESC, last_comment DESC

Upvotes: 0

Alex
Alex

Reputation: 35098

select * from table order by last_comment desc, created

Upvotes: 1

Raj More
Raj More

Reputation: 48024

Here is how to sort rows in MySql

http://dev.mysql.com/doc/refman/5.0/en/sorting-rows.html

Upvotes: 0

Jaymz
Jaymz

Reputation: 6348

select * from table
order by created, last_comment desc

Upvotes: 0

Related Questions