Forum Moderators: open

Message Too Old, No Replies

FullText Search

FullText Search

         

xbl01234

11:20 am on Dec 14, 2006 (gmt 0)

10+ Year Member



Could anyone can tell why the fulltext search could not find all of the word,

for example;
The words with "for, job, man, in",etc, It could not find them

rebelde

11:31 am on Dec 14, 2006 (gmt 0)

10+ Year Member



If you are talking about mySQL, then I think those are all in the "stop-word file".

Putting this in your configuration file and running "repair table" on the effected tables should do the job:
ft_stopword_file=''

The other issue is that you may need to lower the minimum indexed word length with this command:
ft_min_word_len=1

justageek

4:15 pm on Dec 14, 2006 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



[deleted because I didn't read the whole answer right above :-/]

JAG

xbl01234

1:54 am on Dec 15, 2006 (gmt 0)

10+ Year Member



Could you tell where i can find the file configration, is it in control pannel?

rebelde

9:25 am on Dec 15, 2006 (gmt 0)

10+ Year Member



The configuration is usually in the mySQL directory with the rest of the files.

But before you look for it, I recommend spending a couple hours with mySQL's online documentation. A couple hours' study will make it a lot easier to work with.

Jordo needs a drink

8:32 pm on Dec 15, 2006 (gmt 0)

10+ Year Member



Could you tell where i can find the file configration, is it in control pannel?

It sounds like your hosted? If so, you have to get your hosting service to make the change.

xbl01234

8:02 am on Dec 16, 2006 (gmt 0)

10+ Year Member



>It sounds like your hosted? If so, you have to get your hosting >service to make the change.

xbl01234

8:15 am on Dec 16, 2006 (gmt 0)

10+ Year Member



>It sounds like your hosted? If so, you have to get your hosting service to make the change.

Thanks, i will ask my hosting service to do that.