I have a table with a single column that is used to collect search words.
What I want to do is total up the number of times each word appears, ex:
I want to make a list of the words with a count of how many like this:
can I do this with sql or should I do this in code? thanks