# Find Documents by Search Term Examples for MySQL

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

insurance

Will return documents that contain the search term insurance.

auto home

Will return documents that contain auto or home.

+auto +home

Will return documents that contain auto and home.

+insurance -auto

Will return document records that contain insurance and not auto

grocer*

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

For more examples and additional usage information, please see the MySQL Reference Manual.

Notes on special characters:

- * is a multiple wild card character;

- Parenthesis characters () can be used to group words into sub-expressions.

Additional Information:

- Boolean Mode is used for Full-Text searches.

- MySQL contains a stop list of words that will be ignored in full-text searches. The full list can be found here.

- The default minimum length of words that are found by full-text searches is three characters.