On this page

    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.