mysql limit offset

[Anon]

i would like to only select the last 10 records in a db in newest record first.

i know i could first count all records then use this value to do an LIMIT offset query

but i am sure that in mysql 3.22+ this is possible with one command but can't find the reference anywhere

any ideas ????

[steved]

As long as your database table has something that gets bigger with each insert, like an id number or datetime stamp, you can do (for example):

select stuff from mytable order by id desc

The "desc" sets the sort to be in descending order, so you get the biggest number (or newest date) first. Then you can use your limit to set how many rows you want to get back.