Mysql: Calculate visit frequency.

Question

I have this table

CREATE OR REPLACE TABLE hits (ip bigint, page VARCHAR(256), agent VARCHAR(1000), 
                              date datetime)

and I want to calculate googlebot visit frequency for every page.

... WHERE agent like '%Googlebot%' group by page

Answer 1

Use:

  SELECT page,
         COUNT(*)
    FROM hits
   WHERE agent LIKE '%Googlebot%'
GROUP BY page

Answer 2

Try this:

select page, count(1) as visits
  from hits
 where agent like '%Googlebot%'
 group by page;