I've got a table in MySQL 5.0 that has a column defined as char(20). Even
though it has a length of 20 each item in the column is never greater than
9 characters, and each one is unique (this column is the primary key).
Even though each one is unique it's possible two different entries could
have the first 8 characters repeated and only the 9th is different, or in
some cases one entry may only have 8 characters total while another has 9
characters total and the 8 character entry matches the first 8 characters
of the 9 character entry.

Given that, does anyone have any idea of how to get a count of what I may
consider unique: only entries where all 9 characters differ? I would
imagine this would require the use of both count and distinct.

"Those of you who think you know everything are annoying to those of us who do."