Re: SELECT distinct date from log

[Thimble Smith]

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