[PHP-DB] Most Occurring

[Dale Frohman]

Is there anyway with a mysql query to find which item in a particular
field in a table occurs the most frequently?

ie:

table things

field morethings

item1
item2
item1
item1

I would like a query that runs and pulls whatever occurs the most.  In
this case "item1"

Thanks in advance



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]