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
---------------------------------------------------------------------
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
