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.