Simple query examples

Simple queries for the CONTAINS function and the SCORE function search for a single word or multiple words in a text search index.

The search engine ignores white space between characters. A search argument must not be an empty string or contain only blanks.

The following table shows some examples of simple search queries.

Table 1. Simple query examples
Search word types	Examples	Query results
Single word	`king`	Returns all documents that contain the word `king` or `kings`. This query matches linguistic variations of a word and 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 AND operator and the + (plus sign) operator are implicit in every query. For example, the query King Lear returns the same results as King AND Lear or +King +Lear.