Skip to main content
Version: 0.0.1

CONTAINS

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

{{< codeheader "CONTAINS example" >}}

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

Usage Notes​

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