How to reverse order output of a MySQL query

Question

I have a basic write to and retrieve SQL database PHP "thing" and I want to have the output in descending order. How do I do that?

For example, the last entry is shown first, then the entry before that, then the entry before that, etc. The first entry ever is last.

Answer 1

Use:

SELECT field_name
FROM table_name
ORDER BY id DESC

By default, MySQL will show results in ascending order. If you want to show them in reverse order, use ORDER BY field_name DESC.

You can use id or date as the field name.

Answer 2

Change the ORDER BY statement

• from ORDER BY col or ORDER BY col ASC or to ORDER BY col DESC
• from ORDER BY col DESC to ORDER BY col ASC

Answer 3

Sort using DESC ORDER BY.

SELECT * FROM <TABLE> ORDER BY <COLUMN> DESC