I figure since there are various ways to sort information in SQL, there must
be some way to sort the most frequent bit of information. Example:
SELECT term FROM table ORDER BY mostfrequent(term)
And say you had this as the table
ID TERM
1 a
2 a
3 f
4 z
5 a
6 i
7 i
8 z
9 z
10 a
It would return:
a
a
a
a
z
z
z
i
i
f
It there a fuction like that availble built into MySQL?
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
