String

PREFIX

DuckDB

Mengecek apakah string dimulai dengan prefix tertentu. Alias: STARTS_WITH. Mengembalikan boolean.

Tipe hasil: BOOLEANDiperbarui: 6 Jan 2026

Syntax

SQL

PREFIX(string, prefix) | STARTS_WITH(string, prefix)

Parameter

stringVARCHARwajib

String yang akan dicek

prefixVARCHARwajib

Prefix yang dicari di awal string

Contoh Penggunaan

Filter Berdasarkan Kode Produk

SQL

1 SELECT product_code, product_name
2 FROM products
3 WHERE PREFIX(product_code, 'ELC');

Mencari semua produk elektronik berdasarkan prefix kode.

Hasil

product_code	product_name
ELC001	Laptop
ELC002	Smartphone
ELC003	Tablet

Kategorisasi Nomor Telepon

SQL

1 SELECT
2   phone,
3   CASE
4     WHEN PREFIX(phone, '021') THEN 'Jakarta'
5     WHEN PREFIX(phone, '022') THEN 'Bandung'
6     WHEN PREFIX(phone, '031') THEN 'Surabaya'
7     WHEN PREFIX(phone, '08') THEN 'Mobile'
8     ELSE 'Other'
9   END as phone_type
10 FROM contacts;

Mengidentifikasi jenis nomor telepon berdasarkan prefix.

Hasil

phone	phone_type
02112345678	Jakarta
08123456789	Mobile
03145678901	Surabaya

Filter Log Entries

SQL

1 SELECT timestamp, message
2 FROM logs
3 WHERE PREFIX(message, 'ERROR:') OR PREFIX(message, 'FATAL:');

Mencari log entries yang dimulai dengan ERROR atau FATAL.

Hasil

timestamp	message
2024-01-15 10:30:00	ERROR: Connection refused
2024-01-15 10:31:00	FATAL: Database unavailable

Fungsi Terkait

SUFFIX

Kembali ke DuckDB Functions

1	SELECT product_code, product_name
2	FROM products
3	WHERE PREFIX(product_code, 'ELC');

1	SELECT
2	phone,
3	CASE
4	WHEN PREFIX(phone, '021') THEN 'Jakarta'
5	WHEN PREFIX(phone, '022') THEN 'Bandung'
6	WHEN PREFIX(phone, '031') THEN 'Surabaya'
7	WHEN PREFIX(phone, '08') THEN 'Mobile'
8	ELSE 'Other'
9	END as phone_type
10	FROM contacts;

1	SELECT timestamp, message
2	FROM logs
3	WHERE PREFIX(message, 'ERROR:') OR PREFIX(message, 'FATAL:');