Hi all,
I have a table which contains amoung other things, search terms used on our web site. What I'm trying to do is select the count of distinct search terms in one query. I think this is possible, but I can't seem to get the syntax quite right. I've tried things like the following....
SELECT COUNT ( searchTerms ) AS count, DISTINCT searchTerms..... SELECT COUNT ( DISTINCT searchTerms ) AS count, searchTerms.....
But as most of you can probably see from that, it's not working. Can someone give me a nudge in the right direction? I'll work on limiting this query to the top ten or so results once (if) I can get this part of it working. TIA
-- John C. Nichel KegWorks.com 716.856.9675 [EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]