MySQL FullText searching is limited to msyql, not vB, the vB search settings as marco has said do not take effect on mysql's fulltext searches.
We'd need to recompile php, and make it search very tiny words, this would mean the indexes would grow larger and be less useful and drain the server more.
I very much doubt we are going to allow mysql to index 2 letter words.
This is also incorrect. You don't need to do anything with php.
Quote:
The minimum and maximum lengths of words to be indexed are defined by the ft_min_word_len and ft_max_word_len system variables. (See Section 5.2.2, ?Server System Variables?.) The default minimum value is four characters; the default maximum is version dependent. If you change either value, you must rebuild your FULLTEXT indexes. For example, if you want three-character words to be searchable, you can set the ft_min_word_len variable by putting the following lines in an option file:
[mysqld]
ft_min_word_len=3
Then you must restart the server and rebuild your FULLTEXT indexes. Note particularly the remarks regarding myisamchk in the instructions following this list
In addition, MySQL's default stop word list already contains most common 2 letter words. And you can create your own stop word list, again with no need to rebuild anything other than your indexes.
Did I not mention I have this working on my board?
05-23-2006, 09:32 AM
Threaded Mode