Re: php mysql fulltext search min word length = 3
| From: | Marek Kilimajer | Date: | Fri, 27 Sep 2002 15:07:10 +0000 |
| Subject: | Re: php mysql fulltext search min word length = 3 | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-117856@lists.php.net to get a copy of this message | ||
The only option is to recompile mysql
ROBERT MCPEAK wrote:
Much to my dismay, I've learned that the mySQL minimum indexable/searchable word length is 3 characters. This is a real problem for me. Anybody know a workaround, or how to tweak mySQL to allow for matches of words 3 chars or less.From the online mysql docs(http://www.mysql.com/doc/en/Fulltext_Search.html) "MySQL uses a very simple parser to split text into words. A ``word'' is any sequence of characters consisting of letters, numbers, `'', and_'. Any`word'' that is present in the stopword list or is just too short (3 characters or less) is ignored. " Any thoughts, help would be terrific! Thanks!