Search code examples
mysqlsql-order-byauto-increment

Sort by ID DESC

I'm trying to have a blog page order it's entries by the auto incremented unique ID given in descending order, it doesn't seem to allow it. It always appears in ascending order despite the SQL request as written below:

SELECT * FROM news_blog ORDER BY 'news_id' DESC

Is it because the news id is an Integar and therefore doesn't allow for ordering?

Solution

  • If you want to escape column or table names use backticks, not quotes

    SELECT * FROM news_blog
ORDER BY `news_id` DESC

    SQLFiddle demo

    When using quotes the DB thinks you want to sort by the static string 'news_id' which is not sorting at all since it is the same for a records.