[thelist] SQL Most/Count Query

[Chris Blessing]

What do you mean by "similarity"?  Like cats and cats-2 should be counted
together but not actually grouped?  Explain this similarity relationship for
us....

Chris Blessing
webguy at mail.rit.edu
http://www.330i.net

> Ok, try this one on for size,
>
> terms   | other stuff
> ---------------------
> cow     | irrelevant to this posting
> cow     |  "
> horse   |  "
> cat     |
> cat     |
> cow     |
> horse   |
> dog     |
> pig     |
> pig     |
> piggy   |
> cats    |
> cats-2  |
>
> I want to group all entries by name, count them up by similarity, and have
> one item per group of similar/like items shown with the count of
> similar/like items next to them.
>
> :-\
>
> Thanks to who can contribute,
>
> Rob
> --