php mysql fulltext search min word length = 3
| From: | ROBERT MCPEAK | Date: | Fri, 27 Sep 2002 13:58:27 +0000 |
| Subject: | php mysql fulltext search min word length = 3 | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-117847@lists.php.net to get a copy of this message | ||
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!