FIND

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_indexInteger

Return type: Integer

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

ClickHouse 21.8, Microsoft SQL Server 2017 (14.0), MySQL 5.7, Oracle Database 12c (12.1), PostgreSQL 9.3, YDB.

Previous