PLEASE HELP

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
dazz1
Forum Newbie
Posts: 8
Joined: Wed May 14, 2003 8:45 pm

PLEASE HELP

Post 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
[]InTeR[]
Forum Regular
Posts: 416
Joined: Thu Apr 24, 2003 6:51 am
Location: The Netherlands

Post 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.
dazz1
Forum Newbie
Posts: 8
Joined: Wed May 14, 2003 8:45 pm

Post by dazz1 »

i know, i need to know all the words that mysql doesnt use inthe search, like common words
[]InTeR[]
Forum Regular
Posts: 416
Joined: Thu Apr 24, 2003 6:51 am
Location: The Netherlands

Post 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)
dazz1
Forum Newbie
Posts: 8
Joined: Wed May 14, 2003 8:45 pm

Post by dazz1 »

yea i read that too, but i dont know how to load hte 'fucntion' or anythng...pleae help may
Post Reply