# Find Documents by Search Term Examples for SQLite

Below are examples on how to find documents by Search Term using the SQLite database:

insurance

Will return documents that contain the search term insurance.

auto home or auto and home or auto + home

Will return documents that contain auto and home.

insurance not auto

Will return document records that contain insurance and not auto

cars or trains

Will return documents that contain cars or trains.

grocer*

Will return documents that contain the term, beginning with grocer.

Notes on special characters:

- Parenthesis characters () can be used to group terms and operators;

- Common characters, such as – (dash) and & that are part of a string, need to be escaped with an _ (underscore). For example, 2009-10-01 needs to be specified as 2009_10_01.

- Each term can begin with a column name and : (colon) to restrict searching for the specified term in the specified column only. For example, doc_subject:insurance or doc_subject:insurance and doc_added:2020. The following columns are available for searching: doc_title, doc_author, doc_subject, doc_keywords, doc_added, doc_notes, doc_category, doc_tax_year, doc_text_annotations, and doc_text.