Go Back   Singapore Web Hosting Talk > TECHNICAL > Programming Forum

Programming Forum Web applications, languages and other related issues in configuration, optimization, practical usage and database connectivity.

Reply
 
Thread Tools
Old 22-07-2009, 03:18   #1
MumbleVoice-Jen
SGWHT Newbie
 
Join Date: 09-07-2009
Posts: 12
MumbleVoice-Jen is on a distinguished road
mysql query

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!
__________________
MumbleVoice.com - Providing Affordable & Reliable Mumble Voice Hosting Servers since 2001!
MumbleVoice-Jen is offline   Reply With Quote

Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump




All times are GMT +8. The time now is 19:50.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Copyright (C) 2002-2015 Brought to you by Singapore Web Hosting Talk (SGWHT). All Rights Reserved.