By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,384 Members | 714 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,384 IT Pros & Developers. It's quick & easy.

FULLTEXT search, all words must match

100+
P: 160
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.
Jul 29 '11 #1

✓ answered by Rabbit

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

Share this Question
Share on Google+
2 Replies


Rabbit
Expert Mod 10K+
P: 12,359
Do the fulltext search in boolean mode and use the and operator (+).
Jul 29 '11 #2

100+
P: 160
Thanks a lot for your answer
Jul 29 '11 #3

Post your reply

Sign in to post your reply or Sign up for a free account.