mysql query

[MumbleVoice-Jen]

All right guys, I'm having trouble writing a query here's what I'm trying to do:

I have a column (loc) that often contains the same text, what I'm trying to do is to take a count of how many times one name shows up, and see which one shows up the most.
Here's a screenshot of what the column looks like. http://atlservers.com/1.png

I've tried doing a Count distinct, but I can't get the results I need.

Thanks for any help!