Hi Forum,
I know this could be a lengthy question posed, but Ima try to keep it as simple as possible ..
I am trying to find the best method using mysql ver 4.3.4 to calculate the most entries in a column.
The columns (Polling Answers) consists of text strings such as baseball, ice cream, houston, etc
as the poll answers.
Is there a way, or what is the best mysql function to use in order to find the most (max) text
inputs of a column?
In other words, in poll question 1, I ask what is your favorite city? The user selects 1 out of 4
cities, the cities are stored in mysql table as column pq01. I need a formula that will tell me
what cities in column pq01 was selected the most.
Im not sure if this is possible using mysql like this.. but if not, then I need to do the calculations
for the most selected another way for polling..
Thanks for reading.. Any helpful information on this is much appreciated..