The following examples demonstrate some search strings:

'apple banana'

Find rows that contain at least one of the two words.

'+apple +juice'

Find rows that contain both words.

'+apple macintosh'

Find rows that contain the word ``apple'', but rank rows higher if they also contain ``macintosh''.

'+apple -macintosh'

Find rows that contain the word ``apple'' but not ``macintosh''.

'+apple +(>turnover <strudel)'

Find rows that contain the words ``apple'' and ``turnover'', or ``apple'' and ``strudel'' (in any order), but rank ``apple turnover'' higher than ``apple strudel''.

'apple*'

Find rows that contain words such as ``apple'', ``apples'', ``applesauce'', or ``applet''.
This search supports 3 characters searches : 'buy*', '*buy*'
You can also do combinations. For example, if you search for : 'a lua o decizie' is wrong. The correct way to search for that is '+lua* + decizie' or if you search for the exact expression '"a lua o decizie"'.

'"some words"'

Find rows that contain the exact phrase ``some words'' (for example, rows that contain ``some words of wisdom'' but not ``some noise words''). Note that the `"' characters that surround the phrase are operator characters that delimit the phrase. They are not the quotes that surround the search string itself.