MySQL Forums
Forum List  »  Full-Text Search

Re: Using wildcards in fulltext searches
Posted by: Rick James
Date: December 04, 2008 09:14PM

"This is the reason MATCH command allows prefixed wildcards but not postfixed wilcards. Since single words are indexed, a postfix wildcard is impossible to manage in the usual way index does. You can't retrieve '*nited states' instantly from index because left characters are the most important part of index."

-- http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html

Options: ReplyQuote


Subject
Views
Written By
Posted
24306
October 02, 2008 03:14AM
Re: Using wildcards in fulltext searches
9727
December 04, 2008 09:14PM


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.