MySQL Forums
Forum List  »  Full-Text Search

Full-text Number of Occurrences
Posted by: Vaishal Sheth
Date: September 16, 2005 02:50PM

Hello All,

I am trying to write a query that will display the top 5 occuring words in a text column. If you think about it, its result should the same as what I would get if I print the index of that column and order it by the number of occurrences. Is there a way to accomplish this in a SQL statement?

It's not necessarily a full-text search since the user will not be supplying any search term. Somehow, the query has to read the index and display the 5 (or any configured number) of words that occur the most number of times in a field.

I would appreciate any ideas and help,

Thanks,
vps

Options: ReplyQuote


Subject
Views
Written By
Posted
Full-text Number of Occurrences
4429
September 16, 2005 02:50PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.