String

SUFFIX

DuckDB

Mengecek apakah string diakhiri dengan suffix tertentu. Alias: ENDS_WITH. Mengembalikan boolean.

Tipe hasil: BOOLEANDiperbarui: 6 Jan 2026

Syntax

SQL

SUFFIX(string, suffix) | ENDS_WITH(string, suffix)

Parameter

stringVARCHARwajib

String yang akan dicek

suffixVARCHARwajib

Suffix yang dicari di akhir string

Contoh Penggunaan

Filter File Berdasarkan Extension

SQL

1 SELECT filename, size_kb
2 FROM files
3 WHERE SUFFIX(LOWER(filename), '.pdf');

Mencari semua file PDF.

Hasil

filename	size_kb
report_2024.pdf	1250
invoice_001.pdf	85
manual.pdf	3400

Kategorisasi Email Domain

SQL

1 SELECT
2   email,
3   CASE
4     WHEN SUFFIX(email, '.com') THEN 'Commercial'
5     WHEN SUFFIX(email, '.co.id') THEN 'Indonesian Company'
6     WHEN SUFFIX(email, '.edu') THEN 'Educational'
7     WHEN SUFFIX(email, '.gov') THEN 'Government'
8     ELSE 'Other'
9   END as domain_type
10 FROM users;

Mengkategorikan user berdasarkan domain email.

Hasil

email	domain_type
budi@gmail.com	Commercial
ani@company.co.id	Indonesian Company
eko@university.edu	Educational

Validasi Format Nomor

SQL

1 SELECT
2   order_number,
3   SUFFIX(order_number, '-RUSH') as is_rush_order
4 FROM orders;

Mengidentifikasi order rush berdasarkan suffix.

Hasil

order_number	is_rush_order
ORD-2024-001	false
ORD-2024-002-RUSH	true
ORD-2024-003	false

Fungsi Terkait

PREFIX

Kembali ke DuckDB Functions

1	SELECT filename, size_kb
2	FROM files
3	WHERE SUFFIX(LOWER(filename), '.pdf');

1	SELECT
2	email,
3	CASE
4	WHEN SUFFIX(email, '.com') THEN 'Commercial'
5	WHEN SUFFIX(email, '.co.id') THEN 'Indonesian Company'
6	WHEN SUFFIX(email, '.edu') THEN 'Educational'
7	WHEN SUFFIX(email, '.gov') THEN 'Government'
8	ELSE 'Other'
9	END as domain_type
10	FROM users;

1	SELECT
2	order_number,
3	SUFFIX(order_number, '-RUSH') as is_rush_order
4	FROM orders;