Hello,
I am trying to search for 2 words which are close to each other..
In fact, its a name so it should either occur as John, Doe or John Doe
in my fulltext index.. (this particular table is full of emails)
select id,message_subject from email WHERE
MATCH(message_body,message_subject) against ("John Doe") limit 10;
The search returns very unrelated messages... sometimes messages containing
only
John, sometimes messages containing only Doe..
Only one of the messages returned contained "John Doe" together.
Is there a way of telling mysql that these 2 words should occur in close
proximity to each other.. If not
what workarounds could I employ to get my search completed?
Sincerely,
Ovanes
P.S. I tried to change myisam/ftdefs.h as described in the documention,
hoping it would give
better results, but I got the same results.
---------------------------------------------------------------------
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