STARTSWITH (array)
Written by
Updated at November 6, 2024
Function STARTSWITH
is also found in the following categories: String functions.
Syntax
STARTSWITH( array_1, array_2 )
Description
Returns TRUE
if array_1
starts with array_2
.
Argument types:
array_1
—Array of fractional numbers | Array of integers | Array of strings
array_2
—Array of fractional numbers | Array of integers | Array of strings
Return type: Boolean
Examples
STARTSWITH(ARRAY(1, 2, 3), ARRAY(1, 2)) = TRUE
STARTSWITH(ARRAY(1, 2, 3), ARRAY(2, 3)) = FALSE
Data source support
ClickHouse 21.8
, Files
, Google Sheets
, PostgreSQL 9.3
, Yandex Documents
.