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]

Reply via email to