FULLTEXT search, all words must match

[waqasahmed996]

Hi

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.

[Rabbit]

Do the fulltext search in boolean mode and use the and operator (+).

[waqasahmed996]

Thanks a lot for your answer