List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:September 18 2002 10:06pm
Subject:Re: count function issue
View as plain text  
At 16:50 -0500 9/18/02, McIrvin wrote:
>Doing queries to determine the number of times search terms are used on a
>web site.
>
>Here is a sample sql query.
>
>SELECT terms, count(*) AS count FROM searches GROUP BY terms HAVING
>count(*)>1 ORDER BY count DESC
>
>But the results seem to be inaccurate, by no more that 3.

Sorry, it's difficult to parse that last sentence.

Also, since you don't indicate what you expect and what you actually
got, it's hard to say whether what you're seeing is to be expected.

>
>Anyone run into anything like this before?
>
>
>
>---------------------------------------------------------------------
>Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
>
>To request this thread, e-mail <mysql-thread119965@stripped>
>To unsubscribe, e-mail <mysql-unsubscribe-paul=snake.net@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Thread
count function issueMcIrvin19 Sep
  • Re: count function issuePaul DuBois19 Sep
  • Re: count function issueMcIrvin19 Sep
    • Re: count function issuePaul DuBois19 Sep
  • Re: count function issueMcIrvin19 Sep
  • Re: count function issueMcIrvin19 Sep
    • re: Re: count function issueEgor Egorov19 Sep