Hi,
I Save Newsitems in a Database with a Fulltext index on the columns(title,description).
as soon as i match against the string 'for' i get no results:
example:
SELECT *
from articles
where
match(description,title) against('insights') and
match(description,title) against('for')
returns no result.
but:
SELECT *
from articles
where
match(description,title) against('insights') and
match(description,title) against('hat')
returns two rows, if i take a look at the description column of the second row i find:
...Google hat heute die Funktionalität seines Online Analyse Services Google Trends um einen neuen Dienst erweitert Mit Google Insights for Search...
and the string 'for 'is in there, so the first statement should have found that row too. Of course i set ft_min_word_len = 3, otherwise the second statement would have failed too. I also tried rebuilding the index.
any suggestions?
yours sincerely,
J. Oppermann