List:General Discussion« Previous MessageNext Message »
From:Thimble Smith Date:March 20 1999 1:25am
Subject:Re: SELECT distinct date from log
View as plain text  
On Fri, Mar 19, 1999 at 08:17:27PM -0500, Noah Silverman wrote:
> SELECT distinct date from log
> 
> I get a list of every record in table.  Am I doing something wrong??

Not using 'mysqlbug' to send in your problem report :).  What version
are you using?  What OS?

This should work, no matter what version of MySQL you have:

SELECT date FROM log GROUP BY date

You may want to add ORDER BY date, too.

Tim
Thread
SELECT distinct date from logNoah Silverman20 Mar
  • Re: SELECT distinct date from logThimble Smith20 Mar