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 tha
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
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
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
---
