Page 1 of 1

PLEASE HELP

Posted: Tue May 27, 2003 12:55 am
by dazz1
What are the stopwords for Mysql 3.23.47 When you search using FULLTEXT??????

Please help me; when u search using fulltext there are some words that arnt included in ur search

Posted: Tue May 27, 2003 2:02 am
by []InTeR[]
With a filetext search (match against), it's possable that mysql doesn't take all the keywords that you asked for.

The word must be greater then 3 chars long.

Posted: Tue May 27, 2003 4:06 am
by dazz1
i know, i need to know all the words that mysql doesnt use inthe search, like common words

Posted: Tue May 27, 2003 5:45 am
by []InTeR[]
On MySQL.com there is a chapter 6.8.1 Full-text Restrictions. But it shows nothing of restrinctions of the words....

6.8.2 Fine-tuning MySQL Full-text Search says
The stopword list can be loaded from file specified by ft_stopword_file variable. See section 4.5.7.4 SHOW VARIABLES. Rebuild your FULLTEXT indexes after modifying the stopword list. (This variable is only available from MySQL version 4.0.10 and onwards)

Posted: Tue May 27, 2003 2:40 pm
by dazz1
yea i read that too, but i dont know how to load hte 'fucntion' or anythng...pleae help may