Re: php mysql fulltext search min word length = 3

From: 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!


« previous php.general (#117856) next »