Hi

I was going through this tutorial about full text search.

I ran the following query and it worked:

Code:
SELECT entryID,title
FROM blog_entries
WHERE MATCH (title,entry) AGAINST('mother');
But when I ran the following, it didnot work:

Code:
SELECT entryID,title
FROM blog_entries
WHERE MATCH (title,entry) AGAINST('vacation');
Can someone please explain me why as the word "vacation" is already there in the "entry" column in entryID 3?

Many thanks in advance