I would appreciate any advice on this. PHP+MySQL snippets even better :P How can I do this:
For example I have a table with a field FIRST_NAME I want to produce the statistics of how many identical FIRST_NAME entries there are in the table. Yes I could hard code queries to match a list of predetermined entries (ie., knowing that there are common names like Paul, Bob and John) and do a count on each match but this will not suffice because in this example it will not account for say occurrences of the first name Xanther, LOL. Anyway... I had a nap and am back before I clicked send. During my nap I dreamed up something like selecting all FIRST_NAME ordered by same, and them some kind of script to do counts. Any other/further suggestions appreciated. Thanks! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]