Can someone explain the internals of mySQL's "SELECT DISTINCT" ?
I applaud TCX for it's informative online manual.. but this area seems a bit
sparse.
I've got a TEXT column I'm de-duping, so I brewed up a quick Perl/DBI
de-duper..
It only finds 1 dupe out of 3234 rows, where as SELECT DISTINCT .. into
outfile 'foo' counts 2937 to the file.. so, 297 dupes. Right? (That is if a
dupe is A = B)
This is bizarre to me, I trust my script.. the single dupe it found is* 100%
equal to another record.
I spose I'll run it with... text_column like "$thingy" , and see what
happens.
Thanks..
-Jay J
