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 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
Mike(mickalo)Blezien
========================================
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Tel: 1(225) 686-2002
=========================================
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php