String

REGEXP_CONTAINS

BigQuery

Mengembalikan TRUE jika value cocok dengan regular expression. Berguna untuk pattern matching dan validasi format.

Tipe hasil: BOOLDiperbarui: 7 Jan 2026

Syntax

SQL

REGEXP_CONTAINS(value, regexp)

valueSTRINGwajib

String yang akan diuji

regexpSTRINGwajib

Regular expression pattern (re2 syntax)

SQL

1 SELECT
2   email,
3   REGEXP_CONTAINS(email, r'@gmail\.com$') as is_gmail
4 FROM `project.dataset.users`;

Cek apakah email dari Gmail.

Hasil

email	is_gmail
john@gmail.com	true
jane@yahoo.com	false

SQL

1 SELECT
2   phone,
3   REGEXP_CONTAINS(phone, r'^\+62[0-9]{9,12}$') as valid_indo
4 FROM `project.dataset.contacts`;

Validasi format nomor telepon Indonesia.

Hasil

phone	valid_indo
+6281234567890	true
081234567890	false

SQL

1 SELECT *
2 FROM `project.dataset.products`
3 WHERE REGEXP_CONTAINS(sku, r'^[A-Z]{2}-[0-9]{4}$');

Filter products dengan SKU format tertentu.

1	SELECT
2	email,
3	REGEXP_CONTAINS(email, r'@gmail\.com$') as is_gmail
4	FROM `project.dataset.users`;

1	SELECT
2	phone,
3	REGEXP_CONTAINS(phone, r'^\+62[0-9]{9,12}$') as valid_indo
4	FROM `project.dataset.contacts`;

1	SELECT *
2	FROM `project.dataset.products`
3	WHERE REGEXP_CONTAINS(sku, r'^[A-Z]{2}-[0-9]{4}$');