Re: select * on all current?

now its working, i was wondering if we can do max(dateposted) on update? mysql> update datafiles set status = '1' where max(dateposted); ERROR 1111: Invalid use of group function hmm? seems, not to be working at all. On Tue, 27 Jul 2004 14:43:58 +0800, Louie Miranda <lmiranda@gmail.com> wrote: > ok, just removed the distinct syntax > > > > On Mon, 26 Jul 2004 23:51:43 -0500, mos <mos99@fastmail.fm> wrote: > > At 10:45 PM 7/26/2004, you wrote: > > >if I understand you correctly, this should do it. > > > > > >select distinct office, max(dateposted) > > >from table > > >group by office > > > > > > Just one more thing. You don't need "distinct" because you are already > > using "group by". > > > > Mike > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > > http://lists.mysql.com/mysql?unsub=lmiranda@gmail.com > > > > > > > -- > Louie Miranda > http://www.axishift.com > -- Louie Miranda http://www.axishift.com