Selecting last 3 entries only?

[jjfletch]

Hi,

I'm quite the newbie, but can anyone tell me how to create a MySQL query that returns only the last three entries from a table? I tried SELECT TOP..... but it didn't work. (FYI: I'm running mysql 3.23.58)

Thanks.

[homchz]

wouldn't it be

select * from 'table' Limit 3 ORDER desc

?

• = all but you can select what tables you want pulled instead.

[jjfletch]

Well, I'm getting a syntax error with that. Any other suggestions?

[Z3RatuL]

try this, maybe it will work:

select * from 'table' DESC LIMIT 3

discard this message it won't work

[xblue]

ok, first: what do you mean by "last three"? added latest?

keeping in mind that records are not stored in any particular order, you'd then need a column to store the timestamp when a record is added (does not have to be a unix-style timestamp).

then you can easily order by that column, and limit to 3 recordsets (note that LIMIT always goes after ORDER BY).