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. 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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
