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:

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

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
ENDSWITH
Next
ICONTAINS