Addressed to: Dale Frohman <[EMAIL PROTECTED]>
[EMAIL PROTECTED]
** Reply to note from Dale Frohman <[EMAIL PROTECTED]> Thu, 22 Feb 2001 10:34:47
-0500 (EST)
>
> Is there anyway with a mysql query to find which item in a particular
> field in a table occurs the most frequently?
>
>
BDY.RTF
--
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]
you mean the "mode".
I'm afraid you'll have to do it by hand. Other databases do have functions
for a couple of statistics measures( though not sure the mode is included),
but MYSQL doesn't.
Lennin Arriola
[EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe,
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 D