Hi!
On Aug 15, Martin Kjeldsen wrote:
> Hi,
>
> if you use the fulltext to search for words like "internet.com" my
> search allways fails. The reason for is as far as I know that the
> dot (".") is used by the parser as a word separator at least when
> making the index.
>
> The easy way to solve this would be to split the query in 2 words
> "internet" AND "com", but here is the problem that both "com" and
> "internet" exists in more than 50% of the rows.
>
> Offcourse you could search like "field LIKE '%internet.com'%" and this
> will work, but then again there was reasons for changing to the fulltext
> index (speed, relevance and so on).
>
> Is there a way to solve this, can it be solve and will it be solved?
>
> Martin Kjeldsen
>
I see three possible solutions -
first, you can work around this in your application, by changing dot "."
to, e.g., underscore "_" or single quote "'" before INSERT, and restoring your
dots on SELECT.
second, you can change MySQL's notion of "word character" by modifying
word_char() macro in myisam/ft_parser.c
or you can simply get rid of 50% limit by altering myisam/ftdefs.h
(see Fine-tuning Full-text Search, in the manual).
MySQL 4.0 will have boolean fulltext search that does not exhibit 50%-limit
behavior.
Regards,
Sergei
--
MySQL Development Team
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
