James Tyson wrote:
>
> select DISTINCT blah, wibble, fnord
>
> Now, I was under the impression, from what I had read that distinct
> eliminated duplicates from just the column it's used on. However, one of
> my other columns is a unix timestamp (and thus is always different) and
> distinct seems to return all of them.
>
> Am I wrong, or is MySQL wrong?
>
> James Tyson -- System Administrator - The Internet Group.
> It's all good^Hf
distinct works on all explicitly listed columns in the distinct clause.
Van
--
=========================================================================
Linux rocks!!! www.dedserius.com
=========================================================================
