In the last episode (Aug 31), Renald Buter said:
> On 12:27 Thu 31 Aug , Duncan Hill wrote:
> > On Thursday 31 August 2006 12:21, Renald Buter wrote:
> > > The problem is that a simple 1-table query shows different
> > > answers depending on whether you select 1 or 2 columns.
> Of course. I see. How stupid.
> Thanks and sorry to have bothered you.
In your particular case, mysql probably pulled the values for your
1-column query directly from that column's index (which would be
sorted), and your 2-column query either pulled from a different index
or had to actually read table data.