Mysql - How do I retrieve a row with most recent update?

Anyone know how I can retrieve a mysql row from a table that is the most recent update of all rows?


I have a timestamp field on each row that updates whenever an UPDATE command is given to any row. But how do I retrieve the most recent updated row?


Thanks in advance.

 

Hi, phantom

I think here's solution for you:

SELECT *
FROM your_table_name
ORDER BY timestamp_field DESC
LIMIT 1

 

EDIT: Beat me to it.

SELECT
    MAX(timestamp) AS latest
FROM
    table_name
LIMIT 1

Code (sql):

 

ORDER BY DESC is what you are looking for.

Peace,

 

ok I got it guys .......thanks a million to all!