FIND

    String functions

    Syntax

    FIND( string, substring [ , start_index ] )
    

    Description

    Returns the index of the position of the first character of the substring substring in the string string.

    If the start_index option is specified, the search starts from the specified position.

    Argument types:

    • stringString
    • substringString
    • start_indexNumber (whole)

    Return type: Number (whole)

    Examples

    FIND("Lorem ipsum dolor sit amet", "abc") = 0
    
    FIND("Lorem ipsum dolor sit amet", "or") = 2
    
    FIND("Lorem ipsum dolor sit amet", "or", 7) = 16
    

    Data source support

    Materialized Dataset, ClickHouse 1.1, Microsoft SQL Server 2017 (14.0), MySQL 5.6, PostgreSQL 9.3