Mysql 限制和排序依据

Question

我想在表格中显示最后修改的元素，但将结果限制为 5，所以我这样做了:

SELECT
  Id as Id,Title,LastModified
From
  articles
WHERE
  (Author=70 OR Editor=32 OR Publisher=33) && Disab ="0"

Order By   LastModified

LIMIT 0, 5

此查询的问题在于它返回表的前 5 行，而不是最后 5 行编辑...

我错过了什么？!

Answer 1

默认 ORDER BY 是升序。你要降序

SELECT
  Id as Id,Title,LastModified
From
  articles
WHERE
  (Author=70 OR Editor=32 OR Publisher=33) && Disab ="0"

Order By   LastModified DESC

LIMIT 0, 5