Hey Everyone,

First, thanks so much for setting this forum up to whoever did this. I will try my best to explain things. I used to program in MySQL, but having some difficulties with something I think should be simple. Instead of trying to explain this I will put what I have and what I need it to out put.

So if I have a Column like so

Jack data data data
Fred
John
Steve
Jack data data data
Jack data data data
Fred
John

I would like it to output

3 Jack data data data
2 Fred
2 John
1 Steve