FIND

SyntaxSyntax

FIND( string, substring [ , start_index ] )

DescriptionDescription

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:

• string — String
• substring — String
• start_index — Integer

Return type: Integer

ExamplesExamples

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 supportData source support

ClickHouse 21.8, Files, Google Sheets, Microsoft SQL Server 2017 (14.0), MySQL 5.7, Oracle Database 12c (12.1), PostgreSQL 9.3, Trino, Yandex Documents, YDB.