String

CONTAINS_SUBSTR

BigQuery

Mengecek apakah string mengandung substring tertentu. Case-insensitive dan mendukung JSON.

Tipe hasil: BOOLDiperbarui: 7 Jan 2026

Syntax

SQL

CONTAINS_SUBSTR(value, substring)

valueSTRING atau struktur lainwajib

Nilai yang akan dicek (bisa string, array, struct)

substringSTRINGwajib

Substring yang dicari

SQL

1 SELECT CONTAINS_SUBSTR('Hello World', 'WORLD') as result;

Mencari substring (case-insensitive).

Hasil

TRUE

SQL

1 SELECT *
2 FROM `project.dataset.products`
3 WHERE CONTAINS_SUBSTR(TO_JSON_STRING(attributes), 'wireless');

Mencari dalam JSON attributes.

SQL

1 SELECT *
2 FROM `project.dataset.articles`
3 WHERE CONTAINS_SUBSTR(content, 'machine learning')
4   OR CONTAINS_SUBSTR(title, 'machine learning');

Mencari artikel tentang machine learning.

1	SELECT *
2	FROM `project.dataset.products`
3	WHERE CONTAINS_SUBSTR(TO_JSON_STRING(attributes), 'wireless');

1	SELECT *
2	FROM `project.dataset.articles`
3	WHERE CONTAINS_SUBSTR(content, 'machine learning')
4	OR CONTAINS_SUBSTR(title, 'machine learning');