Basic search

You can use boolean operators and modifiers in your search queries. The more specific the search term that you use, the more precise the results.

Example

Example 1: Searches for documents that contain the terms 'wizard' and 'dragon'. The default operator is AND if there is no explicit boolean operator specified.

select title from books where contains(story, 'dragon wizard')=1

Example 2: Searches for documents that contain the phrase 'dragon wizard'. It will not include documents that contain for example, the term 'dragons'.

select title from books where contains(story, "dragon wizard")=1

Example 3: Searches for documents that contain the term 'dragon' and optionally the term 'wizard'. Documents that contain both terms will receive a higher score.

select title from books where contains(story, 'dragon %wizard')=1

Example 4: Searches for documents that contain the terms 'dragon' or 'wizard', but not the term 'hobbit'.

select title from books where contains(story, '(dragon OR wizard) NOT hobbit')=1

Example 5: Searches for documents that contains synonyms of your query terms by using the synonyms dictionary.

select title from books where contains(story, 'dragon wizard','SYNONYM=ON')=1