MySQL: How can I select only the last update for each user?

Posted by KeyStroke on Stack Overflow See other posts from Stack Overflow or by KeyStroke
Published on 2010-04-06T20:31:42Z Indexed on 2010/04/06 20:43 UTC
Read the original article Hit count: 154

Filed under:
|

Say I have a 'user_log' table with the following field:

  • id
  • user_id
  • status_text
  • timestamp

How do I write a query that selects only the last update for all the users in that table?

Appreciate your help :)

© Stack Overflow or respective owner

Related posts about mysql

Related posts about mysql-query