Categories: String

CONTAINS

Returns TRUE if the first expression contains the second expression.

Syntax

CONTAINS(field late, query varchar) → boolean

  • field: The expression to search in.
  • query: The expression to search for.

Examples

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