Dale Frohman wrote:
Is there anyway to do a query and search for the most frequent
word that appears in a particular field in a table?
ie:
ITEM DESCRIPTION
Blue Dog
Red Dog
Yellow Cat
I would want to spit out "Dog" as being the most reoccuring word.
Thanks
On Tue, 27 Feb 2001 13:53:52 -0700, Steve Ruby [EMAIL PROTECTED]
wrote:
You maybe able to adapt the FullText search for this. You can read the details
on this at:
http://www.mysql.com/doc/M/y/MySQL_full-text_search.html
depending what version of MySQL your using.
Is there anyway to do a
I agree, I don't think there is a function in MySql, it will do the job.
May be you can use the following algorithm
1. fetch all rows item description.
2. Split into words and put it in a array.
3. Create a counter array of the same limit of word array.
4. in a for loop, count number of time