Skip to main content
Version: current

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

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.