Does anyone know how I could find out which value in a field, in a database is repeated the most? For example if had a field x and "sports" was a value in that field that was repeated 70 times out of 100 is there a way I could do a mysql search without searching by in the actual word "sports" to get the results? I have a database with about 600 records that I would like to be able to sort by the most occurances of a value in a field, but not actually specify the value. If anyone has any ideas or a better way to do this i would apprecaite the help Thanks!
Greatest number of occurances in mysql
- Thread starter wxdqz
- Start date