String

CONTAINS

Snowflake

Mengecek apakah string mengandung substring. Mengembalikan TRUE jika ditemukan, FALSE jika tidak.

Tipe hasil: BOOLEANDiperbarui: 6 Jan 2026

Syntax

SQL

CONTAINS(string, substring)

stringVARCHARwajib

String yang akan dicek

substringVARCHARwajib

Substring yang dicari

SQL

1 SELECT
2   product_name,
3   CONTAINS(product_name, 'Pro') as is_pro_version
4 FROM products;

Mengecek apakah nama produk mengandung 'Pro'.

Hasil

SQL

1 SELECT *
2 FROM logs
3 WHERE CONTAINS(error_message, 'timeout');

Mencari log yang mengandung kata 'timeout'.

SQL

1 SELECT
2   product_name,
3   CONTAINS(LOWER(product_name), LOWER('apple')) as contains_apple
4 FROM products;

Case-insensitive check dengan LOWER().

CONTAINS_SUBSTR

BigQuery

CONTAINS

DuckDB

1	SELECT
2	product_name,
3	CONTAINS(product_name, 'Pro') as is_pro_version
4	FROM products;

1	SELECT *
2	FROM logs
3	WHERE CONTAINS(error_message, 'timeout');

1	SELECT
2	product_name,
3	CONTAINS(LOWER(product_name), LOWER('apple')) as contains_apple
4	FROM products;