Off the top of me balding head I can think of two things...
One is just leave the dot out and add it in later. Just look for com or couk
net....etc
I also know there is a way of telling SQL that . it a char by putting it in
some kind of "" but I can not remember how....
I hope this helps a bit...
Simon
-----Original Message-----
From: Martin Kjeldsen [mailto:[EMAIL PROTECTED]]
Sent: 15 August 2001 11:41
To: [EMAIL PROTECTED]
Subject: Fulltext problem with '.'
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
---------------------------------------------------------------------
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
