I have a couple of fields: - office - dateposted - filename
now, im having trouble selecting all current "dateposted" per office? i have tried.. sql> select * from datafiles where dateposted current(); And i think its wrong, i could not find how to get it. -- Louie Miranda http://www.axishift.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]