FULLTEXT search, all words must match

waqasahmed996

i read about fulltext search. But i have a question. Can any one please answer.

if search string like this "apple fruit"

then it should give only those results which have both these words(apple,fruit)

for example if data of database field is this
"apple mango fruit"

then it should get above result because it have both words (apple,fruit)

But if data of database field is like this
"apple mango banana"

then this result should not in search because it has only one word (apple).

please let me know if i am not clear in my question.

johanafm

What you're asking is really easy to test yourself. Insert three rows containing 'apple fruit', 'apple magno fruit' amd 'apple mango banana', then try

SELECT text, MATCH(text) AGAINST ('apple fruit' IN NATURAL LANGUAGE MODE) AS relevance
WHERE MATCH(text) AGAINST ('apple fruit' IN NATURAL LANGUAGE MODE)
ORDER BY relevance DESC

waqasahmed996

Thanks a lot for you reply.

i found another way by using plus(+) sign in full text search

thanks again for you reply