I´m stuck..... again..
I´m trying the query the mysql db to get all fields inside a column that are listed more than five times.
For each "5 or more of the same" it should output one hit.
I have no clue how to do this & i can´t find anywhere how to do it either.
Direction pointers would be highly appreciated.
The column below should result in 2, since only mouse & dog appear five times or more.
Thank you in advance,
Best Regards,
Owe Blomqvist
example column:
_________
| CAT |
| CAT |
| CAT |
| MOUSE |
| MOUSE |
| MOUSE |
| MOUSE |
| MOUSE |
| MOUSE |
| DOG |
| DOG |
| DOG |
| DOG |
| DOG |
|________|