newest record

[FengShui1998]

Hello,

I have a table with timestamps. I am trying to find or return the newest/latest record from MySQL. Any ideas? Is there a function that will return the latest record?

Thanks in advance.
fengshui_1998

 

[r937]

SELECT * FROM daTable
WHERE daTimestamp = ( SELECT MAX(daTimestamp) FROM daTable )


r937.com | rudy.ca

 

[DonQuichote]

Or:

SELECT * FROM daTable ORDER BY daTimestamp DESC LIMIT 1;

In any case, make sure you set an index on the timestamp field.

+++ Despite being wrong in every important aspect, that is a very good analogy +++
Hex (in Darwin's Watch)