String

STARTS_WITH

BigQuery

Mengecek apakah string dimulai dengan prefix tertentu. Return boolean.

Tipe hasil: BOOLDiperbarui: 7 Jan 2026

Syntax

SQL

STARTS_WITH(value, prefix)

Parameter

valueSTRINGwajib

String yang akan dicek

prefixSTRINGwajib

Prefix yang dicari

Contoh Penggunaan

Check Prefix

SQL

1 SELECT STARTS_WITH('BigQuery', 'Big') as result;

Mengecek apakah dimulai dengan 'Big'.

Hasil

TRUE

Filter by Prefix

SQL

1 SELECT *
2 FROM `project.dataset.products`
3 WHERE STARTS_WITH(sku, 'ELC');

Filter produk elektronik berdasarkan SKU prefix.

Categorize by Prefix

SQL

1 SELECT
2   CASE
3     WHEN STARTS_WITH(email, 'admin') THEN 'Admin'
4     WHEN STARTS_WITH(email, 'support') THEN 'Support'
5     ELSE 'Regular'
6   END as user_type,
7   COUNT(*) as count
8 FROM `project.dataset.users`
9 GROUP BY user_type;

Kategorisasi user berdasarkan email prefix.

Fungsi Terkait

ENDS_WITH

Kembali ke BigQuery Functions

1	SELECT *
2	FROM `project.dataset.products`
3	WHERE STARTS_WITH(sku, 'ELC');

1	SELECT
2	CASE
3	WHEN STARTS_WITH(email, 'admin') THEN 'Admin'
4	WHEN STARTS_WITH(email, 'support') THEN 'Support'
5	ELSE 'Regular'
6	END as user_type,
7	COUNT(*) as count
8	FROM `project.dataset.users`
9	GROUP BY user_type;