From: Thimble Smith
Date: March 20 1999 1:25am
Subject: Re: SELECT distinct date from log
List-Archive: http://lists.mysql.com/mysql/669
Message-Id: <19990319182551.U17225@desert.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

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