Categories: String

CONTAINS

Returns TRUE if the first expression contains the second expression.

Syntax

CONTAINS(expression1 varchar, expression2 varchar) → boolean

• expression1: The string to search in.
• expression2: The string to search for.

Examples

SELECT CONTAINS('dremio sql lakehouse', 'lake')
-- True

Usage Notes

This function uses the Lucene syntax and can only be used with Elasticsearch sources.