Most Occurring
| From: | Dale Frohman | Date: | Thu, 22 Feb 2001 15:34:47 +0000 |
| Subject: | Most Occurring | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-6866@lists.php.net to get a copy of this message | ||
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