0

I am using full text search feature of mysql for searching through comments. To use stemming, I am using "form of" in the query. This gives me the correct result, returning all comments having the any word form of the search text.

However, I need to highlight all these word forms in the comments displayed, and as a result I need the entire list of word forms. How do I get the list of these word forms.

Currently, my query looks like :- 

SELECT * FROM table WHERE MATCH (comment_text)
AGAINST (' FORM OF "search_term"' );

I require a list of all the word forms of the search_term, which were used by mysql internally.

Gyanendra Singh
  • 895
  • 2
  • 13
  • 30
  • `FORM OF` is not a native MySQL modifier. The only native way to search for word stems is with the `*` wildcard operator `IN BOOLEAN MODE`. You must be using a third party plugin? – eggyal Dec 26 '13 at 16:05
  • No, I'm not using any third party plugins. – Gyanendra Singh Dec 29 '13 at 12:35
  • It looks like the FORM OF syntax is planned for release 7.1. http://dev.mysql.com/worklog/task/?id=2423 – Vincent Jul 06 '14 at 17:34

0 Answers0