Count occurences of a string?

Yari

HI, I hope this doesn't sound too simple, but I have spent the better part of today trying to work it out.

I have a table with about 52,000 records, what I wanted was a summary of the most popular page etc.

Is there an easy way, using MYSQL, to count the number of occurences of a string in the records, and return the MAX??

MAX only works on integers.... any ideas?

Also, if I do find the most common page overrall, is there a way to show how many times it has been accessed too? I.e. count the number of occurences, all in the same SELECT statement?

Cheers,

Yari

drawmack

http://www.mysql.com/select - pay attention to the group by directive

http://www.mysql.com/count

Then you would do something like this:
SELECT count(<id>) FROM <table> GROUP BY <field>

Yari

Thanks alot, I will give this a try on Monday, I hope it works!

Thanks for you time,

Yari

WOW!!! It works... beautifully.!!

You don't know how many hours, no days, you have saved me! And I imagine it will be soo much fast than what I was doing...

You are a legend. Thank you very much for your help!

Regards,

Yari