That gets REALLY hairy since you don't know the words you're looking for ahead of time. In other words, it would be relatively easy to say "tell me how many times the word ColdFusion is used in this field," but generating a list from nothing turns that problem on its head and makes it a lot more messy.
The first thing that comes to my mind is that you'd have to grab everything first, "chunkify" (to use a PHP function name) all of it into word lists, then maybe do some sorting and then loop through doing counts along the way for each chunk of similar words. There's probably a more elegant solution, but that would be the brute-force method. Matt On Apr 6, 2005 8:04 AM, Jake McKee <[EMAIL PROTECTED]> wrote: > Simpler than it sounds. > > I want to generated a list of, say the top 10 words used in entries in a > particular column of the database. > > So let's say I have a "Title" field in my db... I want to generated a > list of the most used words in all the entries in that field. > > Make sense? > > Ryan Everhart wrote: > > >Jake, > >Not sure I understand the question completely. Can you give us an > >example of what you want to do? > > > >Ryan > > > > > >On Apr 6, 2005 7:47 AM, Jake McKee <[EMAIL PROTECTED]> wrote: > > > > > >>OK, I've not seen this one discussed anywhere, so perhaps it's a new > >>question... probably not. > >> > >>If I wanted to generate a report of some sort on which words in a > >>particular DB column are used the most, how would I do that? > >> > >>Jake > >> > >>---------------------------------------------------------- > >>To post, send email to [email protected] > >>To unsubscribe: > >> http://www.dfwcfug.org/form_MemberUnsubscribe.cfm > >>To subscribe: > >> http://www.dfwcfug.org/form_MemberRegistration.cfm > >> > >> > >> > >> > >---------------------------------------------------------- > >To post, send email to [email protected] > >To unsubscribe: > > http://www.dfwcfug.org/form_MemberUnsubscribe.cfm > >To subscribe: > > http://www.dfwcfug.org/form_MemberRegistration.cfm > > > > > > > > > > > > > > > > > > ---------------------------------------------------------- > To post, send email to [email protected] > To unsubscribe: > http://www.dfwcfug.org/form_MemberUnsubscribe.cfm > To subscribe: > http://www.dfwcfug.org/form_MemberRegistration.cfm > > -- Matt Woodward [EMAIL PROTECTED] http://www.mattwoodward.com ---------------------------------------------------------- To post, send email to [email protected] To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm
