MYSQL选择最后3行，按ASC顺序排序 [英] MYSQL select last 3 rows, order by ASC

问题描述

我只想在帖子中选择最新的3条评论，并按ASC顺序排序.

I just want to select the newest 3 comments on a post, and have them ordered in ASC order.

这将选择最后3行，但是我需要相反的顺序:

This selects the last 3 rows, however I need them in the reverse order:

mysql_query("
SELECT * FROM comments WHERE postID='$id' AND state='0' ORDER BY id DESC LIMIT 3")

推荐答案

您可以稍后对其进行反向排序.

You can reverse sort it later.

SELECT * 
FROM (SELECT * FROM comments
      WHERE postID='$id' 
        AND state='0' 
      ORDER BY id DESC 
      LIMIT 3) t
ORDER BY id ASC;

这篇关于MYSQL选择最后3行，按ASC顺序排序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！