McIrvin,
Thursday, September 19, 2002, 2:41:35 AM, you wrote:
M> No,, I dumped the table and put it on a different server and tried it there.
Could you send a dump of the table to test it?
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by
No,, I dumped the table and put it on a different server and tried it there.
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "McIrvin" <[EMAIL PROTECTED]>
Sent: Wednesday, September 18, 2002 6:37 PM
Subject: Re: count function
Thanks but no change.
--=C
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "McIrvin" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, September 18, 2002 5:41 PM
Subject: Re: count function issue
> At 17:26 -0500 9/1
AIL PROTECTED]>
>To: "McIrvin" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
>Sent: Wednesday, September 18, 2002 5:06 PM
>Subject: Re: count function issue
>
>
>> At 16:50 -0500 9/18/02, McIrvin wrote:
>> >Doing queries to determine the number of
more than 3 instances.
--=C
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "McIrvin" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, September 18, 2002 5:06 PM
Subject: Re: count function issue
> At 16:50 -0500 9/18/02, Mc
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 inaccurat