POSITION

Returns the position of the substring found in the string, starting from 1. The returned value is for the first matching value, and not for any subsequent valid matches. In case the substring does not exist, functions will return 0.

Syntax

POSITION(<substring> IN <string>)

Parameters

Parameter	Description	Supported input types
`<substring>`	The substring to search for.	`TEXT`
`<string>`	The string that will be searched.	`TEXT`

Return Type

INTEGER

Examples

SELECT POSITION('hello' IN 'hello world') AS res;

res int
1

Rows: 1Execution time: 5.73ms

SELECT POSITION('world' IN 'hello world') AS res;

res int
7

Rows: 1Execution time: 5.34ms

SELECT POSITION('work' IN 'hello world') AS res;

res int
0

Rows: 1Execution time: 4.65ms

OCTET_LENGTH

REGEXP_EXTRACT_ALL

⌘I

Overview

Performance and Observability

Security

Self-Managed

Managed service

Guides

SQL reference

Release notes

API reference

Legal

Syntax

Parameters

Return Type

Examples

​Syntax

​Parameters

​Return Type

​Examples

Syntax

Parameters

Return Type

Examples