MySQL Forums
Forum List  »  Full-Text Search

Search based on the words
Posted by: Amit Kumar
Date: June 13, 2017 06:49AM

Dear friends,

Is there any way to consider two words as one.

example if I am searching for
1. ' "green apple" are sweet '
2. ' " green apple " are better then "red apple" '

1 search string : "green apple" are sweet
words present: (i) green apple
(ii) are
(iii) sweet .
2 search string : " green apple " are better then "red apple"
words present :(i) green apple
(ii) are
(iii) better
(iV) then
(v) red apple

in first scenario , it consider "green apple" are only one word while searching. that makes it has three words green apple , and are and sweet.
in second it consider "green apple" as one word , are is second word , better is third word ,then is fourth word and "red apple" is fifth word.

So whenever it does the search , these words will always comes together.

Do i have to write multiple match against clauses here ...

Options: ReplyQuote

Written By
Search based on the words
June 13, 2017 06:49AM

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.