Re: Keyword Search Issue in MySQL
Stemming does not help with the selection of "Iron Pigs" or "IronPigs" as that is 2 words or 1 word respectively.
Stemming would convert the words directory and directories to directori (may not be the correct stem but illustrates the point).
One option you have is to build a list of common miss spellings then when you get zero results compare the query term against the list and put up a message did you mean ....
Another option is to run the like query if the full text match fails, but then you still have no rank.
|