"leegold" <[EMAIL PROTECTED]> wrote on 12/12/2005 03:18:30 PM:
> Is there a tech term for this? User searches for "reviews" but the > actual word is "review". So the search engine code searchs on bolth > words and user gets the hit they want... > > What's this called? Is there a MYSQL implementation of this? > > Thanks > That is a form of "stemming". No, MySQL does not implement stemmed searches. It is up to your application to first stem the search word and build a query appropriate to it. In this case you want to remove the trailing "s" to reveal the stem "review". Next you want to do a wildcard search for "review%" which will return review, reviewing, reviewed, reviewer, etc. If a full wildcard search or a more specific type of stemmed search is your need (like looking only for noun or verb forms based on grammar) that would be a more complex type of search. I am sure if you search the web, you will find lots of different algorithms for stemming. MySQL supports both full-text and standard indexes. Both of which can be used for wildcard searches (as long as the wildcard character is at the END of the string). Did that help? Shawn Green Database Administrator Unimin Corporation - Spruce Pine
