If I've understood you what I want, then MySQL time functions can help. It is always possible to substract time with MySQL. So if you substract the value of your column "TIMESTAMP" from current time, you will get all records that are older than now. I can't try it now, but I believe something in this direction could help you:
SELECT distinct LOGIN, TIMESTAMP, IP from SESSIONS WHERE CURRENT_TIMESTAMP - TIMESTAMP = 0 || > 0 Note that, I did not try it. HTH Babs -----Ursprüngliche Nachricht----- Von: motorpsychkill [mailto:[EMAIL PROTECTED] Gesendet: Samstag, 20. März 2004 02:18 An: mysql Betreff: retrieving last record for all distinct users I have a table SESSIONS with the following fields: SESSION_ID LOGIN IP TIMESTAMP I am trying to select the last login record for all distinct users. The closest I can get to is: select distinct LOGIN, TIMESTAMP, IP from SESSIONS group by LOGIN order by TIMESTAMP desc This kind of works but it does not get the correct IP for the last TIMESTAMP. This seems easy enough, but I can't seem to figure this one out today. Can anybody see what I'm missing? Thanks! -m -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]