fultext help

[dd1313]

Hi Guys

I was reading here

http://www.onlamp.com/pub/a/onlamp/2.../fulltext.html

under restrictions that fulltext only returns results if there are 3 or more rows..

Is that correct ?

Thanks
DD

[longneck]

no, that is not correct. it is a misinterpretation of the 50% rule.

a search term that matches 50% or more of the rows will be ignored. if you have only 2 rows, then all terms will always match 0%, 50%, or 100% of the rows, and therefore the query will return 0 rows.

so the minimum number of rows needed to get any results is 3.

[dd1313]

no, that is not correct. it is a misinterpretation of the 50% rule.

a search term that matches 50% or more of the rows will be ignored. if you have only 2 rows, then all terms will always match 0%, 50%, or 100% of the rows, and therefore the query will return 0 rows.

so the minimum number of rows needed to get any results is 3.

Thank you

DD