Hello,
I'm having problems getting the fulltext search to return useful results. I
wan't to query all the results in my table that contain all of the search
words entered. I don't have mysql 4.0 so I can't use the binary search.
If I use "... where match field against ('word1') and match field against
('word2')" then I get what I want, except that short words and words that
return no results cause the whole query to return no results.
Is there anyway to do a search of items contains all my words using the 3.23
fulltext search, and have the results returned in a decent order?
Thanks,
Chris
---------------------------------------------------------------------
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
