String

REGEXP_LIKE

Snowflake

Mengecek apakah string cocok dengan regex pattern. Mengembalikan TRUE/FALSE.

Tipe hasil: BOOLEANDiperbarui: 6 Jan 2026

Syntax

SQL

REGEXP_LIKE(string, pattern [, parameters]) | string REGEXP pattern

stringVARCHARwajib

String yang akan dicek

patternVARCHARwajib

Regular expression pattern

parametersVARCHARopsional

Flags: i=case-insensitive, c=case-sensitive, m=multiline

SQL

1 SELECT
2   email,
3   REGEXP_LIKE(email, '^[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+\\.[A-Za-z]{2,}$') as is_valid_email
4 FROM users;

Memvalidasi format email.

Hasil

EMAIL	IS_VALID_EMAIL
john@example.com	TRUE
invalid-email	FALSE

SQL

1 SELECT *
2 FROM products
3 WHERE product_code REGEXP '^[A-Z]{2}-[0-9]{4}$';

Mencari produk dengan kode format XX-9999.

SQL

1 SELECT REGEXP_LIKE('+62812345678', '^\\+62[0-9]{9,12}$') as valid_phone;

Memvalidasi format nomor telepon Indonesia.

Hasil

TRUE

1	SELECT
2	email,
3	REGEXP_LIKE(email, '^[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+\\.[A-Za-z]{2,}$') as is_valid_email
4	FROM users;