I have a timestamp(14) column, I need to expire/decay certain records over time, can I use NOW() and INTERVAL on a timestamp(14) column
Looking to expire a record that is x hours old For example Update table set active = '0' where updated = ???? -- ------------------------------------------------------------- Scott Haneda Tel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED] Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
