apple banana
Finds rows that contain at least one of a list of words

+apple +banana
Finds rows that contain all words

+apple banana
Finds rows that contain 'apple' but rank rows higher if also contain 'banana'

+apple -banana
Finds rows that contain 'apple' but not 'banana'

+apple +(>banana <pear)
Finds rows that contain 'apple and banana' or 'apple and pear' , but rank apple pear higher

apple*
Finds rows that contain 'apple' or 'apples' or 'applesauce' etc

"some apples"
Finds rows that contain the exact phrase 'some apples'