Update timestamp with a select

Hi, does anyone know if it's possible for a timestamp column to
automatically update itself when a select is made? We have a
user/password/roles database that is accessed by Tomcat's j_security module
whenever a user logs into one of our webapps, and I want to know which users
haven't logged in recently so that I can erase their accounts. I would
appreciate all of your feedback on this one.

Thanks!

Paulo Urcid Pliego
E-Labor Producción DM e IM
Preserie y Construcción de Equipos
 
Volkswagen de México S.A. de C.V.
Teléfono +52 (222) 2 30 9961
Fax +52 (222) 2 30 6082
mailto:[email protected]
http://www.vw.com.mx

-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    http://lists.mysql.com/[email protected]