[thelist] SQL Most/Count Query
Rob Smith
rob.smith at THERMON.com
Thu Nov 14 13:21:01 CST 2002
Supplement info about this:
I've been recording what people are searching for on my site for the past
few months and had close to 2k searches a month. I want to know what people
are searching for most, second, and so on.
Rob
-----Original Message-----
From: Rob Smith [mailto:rob.smith at THERMON.com]
Sent: Thursday, November 14, 2002 1:21 PM
To: 'thelist at lists.evolt.org'
Subject: [thelist] SQL Most/Count Query
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 !
More information about the thelist
mailing list