Examples: Simple text search

The CONTAINS and SCORE functions can be used to perform a simple text search for a single word or multiple words in a text search index.

The search engine ignores white space between characters. An empty search argument, or one that contains only blanks, does not match anything.

The following table shows some examples of simple text search requests.

Table 1. Simple text search examples
Search word types	Examples	Search results
Single word	`king`	Returns all documents that contain the word `king` or `kings`. The search is not case-sensitive.
Multiple words	`king lear`	Returns all documents that contain `king` and `lear`. The default operator is the logical operator AND.

The operators AND and + (plus sign) are implicit in every text search. For example, the text search for King Lear returns the same results as King AND Lear or King + Lear.

You must enter the logical operators NOT, AND, and OR in all uppercase.