In Full Text Search in boolean mode if we search
'apple*'
It will find Find rows that contain words such as apple, apples, applesauce, or applet.
if we search
'apple banana'
It will find rows that contain at least one of the two words.
Is it possible that search 'apple banana' will give result same as
Expand|Select|Wrap|Line Numbers
- Select * from table where filed LIKE 'apple banana%'
apple banana
apple banana mango
apple bananadates
one option is to use double quotes (")
but it will not give result 'apple bananadates'
please is there any solution that i find all above three record with full text search (match-against)