[thelist] SQL Most/Count Query

[Rob Smith]

Ok Chris (and group)

cats and cats-2 are two completely different items. I want to sort through
my couple of thousand rows into explicit search strings. for example I have
14 JCKa's and 29 JCKb's.

Rob

-----Original Message-----
From: Chris Blessing [mailto:webguy at mail.rit.edu]
Sent: Thursday, November 14, 2002 1:26 PM
To: thelist at lists.evolt.org
Subject: RE: [thelist] SQL Most/Count Query


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
> --

--
* * Please support the community that supports you.  * *
http://evolt.org/help_support_evolt/

For unsubscribe and other options, including the Tip Harvester
and archives of thelist go to: http://lists.evolt.org
Workers of the Web, evolt !