Re: [mysql-84] Full Text Search

That's it !!!
Thank you Dan, very much.




On Thu, Apr 24, 2008 at 8:39 AM, Dan Makovec <[address removed]> wrote:
> Actually it's not totally clear how to remove it.  It does show you the
> default words not indexed though.
>
> Do as follows:
>
> In your my.cnf file, add the following lines:
>
>
> [mysqld]
> ft_min_word_len=3
> ft_stopword_file=/etc/mysql_ft_stopwords
>
> The first line specifies that you want to index on words as short as three
> letters long e.g. like "the" - this may or may not suit you.
> The second line points to a plain text file you create containing the words
> you DON'T want to index, one word per line, e.g:
>
>
> a's
> according
> accordingly
> afterwards
> against
> ain't
> all
> allow
> allows
>
> After you've set these parameters, you'll need to restart mysql, then
> REBUILD THE FULLTEXT INDEX (don't forget the second part or you'll wonder
> why it's not working after you change your .cnf).
>
> Hope that helps!
>
> Luv,
> d
>
>
>
>
> Dan Makovec
> [address removed]
> www.makovec.net
>
>
>
> On 24/04/2008, at 8:32 AM, Dan Makovec wrote:
>
> Hi Mark,
>
> See the "stopwords" list at:
>
> http://dev.mysql....
>
> You'll find "various" is in that list.  You'll also find instructions for
> kicking it out :)
>
> Luv,
> d
>
>
>
> Dan Makovec
> [address removed]
> www.makovec.net
>
>
> On 24/04/2008, at 8:17 AM, Mark Unwin wrote:
> Dear Interweb....
>
>  Am trying to do a full text query using the
> match(col1, col2, col3) against('$search_term' in boolean mode)
>  expression.
>  All seems OK. I can search and retrieve rankings for the different
> columns, etc, etc.
>  EXCEPT..... If I use a search term of "various", nothing is returned.
> Not one row. And yes, "various" _is_ present in some columns.
>  Is "various" a special case here, or am I missing something.
>  I think I am doing everything correctly, because other (any other)
> search term(s) work just fine.
>  Only "various" returns nothing.
>
>  I have even tried creating a full text index, and dropping the "in
> boolean mode" - it makes no difference.
>
>  Thanks in advance,
>  Mark "confused" Unwin.
>
>
>
> --
> Please Note: If you hit "REPLY", your message will be sent to everyone on
> this mailing list ([address removed])
> http://mysql.meet...
> This message was sent by Mark Unwin ([address removed]) from MySQL User
> Group Brisbane.
> To learn more about Mark Unwin, visit his/her member profile:
> http://mysql.meet...
> To unsubscribe or to update your mailing list settings, click here:
> http://www.meetup...
>
> Meetup Support: [address removed]
> 632 Broadway New York NY 10012 USA
>
>
>
>
>
>
>  --
>  Please Note: If you hit "REPLY", your message will be sent to everyone on
> this mailing list ([address removed])
>  This message was sent by Dan Makovec ([address removed]) from MySQL User
> Group Brisbane.
>  To learn more about Dan Makovec, visit his/her member profile
>  To unsubscribe or to update your mailing list settings, click here
>
>  Meetup Support: [address removed]
>  632 Broadway New York NY 10012 USA
>
>
>
>
>
>  --
>  Please Note: If you hit "REPLY", your message will be sent to everyone on
> this mailing list ([address removed])
>  This message was sent by Dan Makovec ([address removed]) from MySQL User
> Group Brisbane.
>  To learn more about Dan Makovec, visit his/her member profile
>  To unsubscribe or to update your mailing list settings, click here
>
>  Meetup Support: [address removed]
>  632 Broadway New York NY 10012 USA