How can I select rows in reverse order in MySQL?

Question

How can I select rows in reverse order in MySQL?

For example, I have a table with 12 rows (fields: id,location), I want to select the 4th row before a row with id = 6. I.e., the wanted row will have id = 'not necessarily 2', but there is a condition - where table.location='some_location'.

What should the content of request to MySQL be like?

---

Here is a solution!

Some example (I checked drodil's suggestion):

mysql> select * from subscrs where id < 100000 order by id desc limit 4;
+-------+--------+-----------+-------+
| uid   | subscr | event     | id    |
+-------+--------+-----------+-------+
|  5307 |   5123 | feed_news | 99999 |
| 25985 |   5211 | feed_news | 99998 |
| 15123 |    130 | feed_news | 99997 |
| 28368 |  19497 | feed_news | 99996 |
+-------+--------+-----------+-------+
4 rows in set (0.00 sec)

Answer 1

Or you could do it without caring about the deleted results. Just get the fourth before the given id (6) by:

SELECT * FROM SomeTable WHERE id < 6 ORDER BY id DESC LIMIT 4,1

Answer 2

Please add ORDER BY id DESC in the last of your query to fetch the data from last to first.

OR

For assenting order, you can simply add ORDER BY id ASC.