Hi, Is there a way to prevent the 50% occurence threshold in mysql's fulltext search logic that causes words that appear in more than 50% of records to be considered stopwords? I have a table that has less than 1000 records and would like to do a fulltext search on two columns and have them returned in plain old 'nearest match' order, rather than 'weighted words based on occurences of the word' order.
>From the manual: >"Word MySQL is present in more than half of rows, and as such, is effectively treated as a stopword (that is, with >semantical value zero). It is, really, the desired behavior - a natural language query should not return every second >row in 1GB table. " I don't desire this behaviour. I don't mind every second row in the table, as long as they're ordered by best match first, and no words are ignored, regardless of how frequently they appear. I saw mention of the 'boolean search' that seems to disregard the 50% threshold, but that's only in version 4.0.1 which isn't released yet, and I'm not sure if it will order by best match first. thanks for all your help, Mark. --------------------------------------------------------------------- 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
