MySQL Forums
Forum List  »  Full-Text Search

match against('for')
Posted by: Janosch Oppermann
Date: August 06, 2008 09:03AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
match against('for')
8207
August 06, 2008 09:03AM
3813
August 07, 2008 05:07AM
3696
August 07, 2008 08:08AM
3302
August 11, 2008 10:46AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.