String

CONTAINS

DuckDBDuckDB

Mengecek apakah string mengandung substring tertentu. Mengembalikan boolean TRUE/FALSE. Lebih readable dari STRPOS > 0.

Tipe hasil: BOOLEANDiperbarui: 6 Jan 2026

Syntax

SQL
CONTAINS(string, substring)

Parameter

stringVARCHARwajib

String yang akan dicek

substringVARCHARwajib

Substring yang dicari

Contoh Penggunaan

Filter Produk yang Mengandung Kata

SQL
1SELECT product_name, price
2FROM products
3WHERE CONTAINS(LOWER(product_name), 'gaming');

Mencari semua produk gaming (case-insensitive).

Hasil
product_nameprice
Gaming Laptop25000000
Gaming Mouse750000
Gaming Keyboard1500000

Kategorisasi Email Domain

SQL
1SELECT
2  email,
3  CASE
4    WHEN CONTAINS(email, '@gmail.com') THEN 'Gmail'
5    WHEN CONTAINS(email, '@yahoo.com') THEN 'Yahoo'
6    WHEN CONTAINS(email, '@outlook.com') THEN 'Outlook'
7    ELSE 'Other'
8  END as email_provider
9FROM users;

Mengkategorikan user berdasarkan email provider.

Hasil
emailemail_provider
budi@gmail.comGmail
ani@yahoo.comYahoo
eko@company.co.idOther

Validasi Format Data

SQL
1SELECT
2  phone,
3  CASE
4    WHEN CONTAINS(phone, '+62') THEN 'Indonesian'
5    WHEN CONTAINS(phone, '+1') THEN 'US'
6    ELSE 'Unknown'
7  END as country
8FROM contacts;

Mengidentifikasi negara berdasarkan kode telepon.

Hasil
phonecountry
+6281234567890Indonesian
+14155551234US
08123456789Unknown

Fungsi Terkait

POSITIONSTRPOS
Kembali ke DuckDB Functions