FullTextContains (NoSQL query)

APPLIES TO: NoSQL

Returns a boolean indicating whether the keyword string expression is contained in a specified property path.

Syntax

FullTextContains(<property_path>, <string_expr>)  

Arguments

Description
property_path The property path to search.
string_expr The string to find.

Return types

Returns a boolean expression.

Examples

This is a simple query returning 10 results that contain "keyword" in the c.text property.

SELECT TOP 10 *
FROM c
WHERE FullTextContains(c.text, "keyword")

This next example shows logical operators used for ensuring multiple keywords are included.

SELECT *
FROM c
WHERE FullTextContains(c.text, "keyword1") AND  FullTextContains(c.text, "keyword2")

Remarks