How to reverse order output of a MySQL query

by

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.

More Related Contents:

  1. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘WHERE `id` [closed]
  2. Using PHP data in MySQL [closed]
  3. Checking the availability of rooms
  4. How to properly set up a PDO connection
  5. Commands out of sync; you can’t run this command now
  6. SELECT COUNT(*) AS count – How to use this count
  7. Get table column names in MySQL?
  8. How to resolve ambiguous column names when retrieving results?
  9. Loading .sql files from within PHP
  10. selecting unique values from a column
  11. Use bound parameter multiple times
  12. MySQL “NOT IN” query 3 tables
  13. Create a dynamic mysql query using php variables
  14. PHP: multiple SQL queries in one mysql_query statement
  15. How to separate DATE and TIME from DATETIME in MySQL?
  16. Why does this return Resource id #2? [duplicate]
  17. MySQL skipping first row
  18. Fatal error: Uncaught exception ‘mysqli_sql_exception’ with message ‘No index used in query/prepared statement’
  19. How to generate unique id in MySQL?
  20. Simple PHP SQL login troubleshooting
  21. MySql PHP select count of distinct values from comma separated data (tags)
  22. How to SELECT DEFAULT value of a field
  23. How to check if a value already exists to avoid duplicates?
  24. how do I get month from date in mysql
  25. php/mysql zip code proximity search
  26. Updating column so that it contains the row position
  27. MYSQL select a piece of a string and order by that piece
  28. Aggregated query without GROUP BY
  29. PHP/MySQL Pagination
  30. Limit pagination page number

Leave a Comment