[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