Is there any way I can get the last x results from a table? For example, I have code that will extract 5 results from a table using LIMIT 5, but this only searches from the top. Is there any way I can get it to search from the bottom and get the first 5 results from the bottom of the table?
If you have 'something' that identifies the 'Top' 5 items
SELECT * FROM sometable ORDER BY something LIMIT 5
Then easiest is
SELECT * FROM sometable ORDER BY something DESC LIMIT 5