re: Re: count function issue

2002-09-19 Thread Egor Egorov
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

Re: count function issue

2002-09-18 Thread McIrvin
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

Re: count function issue

2002-09-18 Thread McIrvin
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

Re: count function issue

2002-09-18 Thread Paul DuBois
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

Re: count function issue

2002-09-18 Thread McIrvin
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

Re: count function issue

2002-09-18 Thread Paul DuBois
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