String

REGEXP_REPLACE

MySQL

Mengganti substring yang cocok dengan pattern regex. Tersedia di MySQL 8.0+.

Tipe hasil: VARCHARDiperbarui: 7 Jan 2026

Syntax

SQL

REGEXP_REPLACE(expr, pat, repl [, pos [, occurrence [, match_type]]])

exprstringwajib

String sumber

patstringwajib

Pattern regular expression

replstringwajib

String pengganti

posintegeropsional

Posisi awal pencarian

Default: 1

occurrenceintegeropsional

Kemunculan ke-n yang diganti (0=semua)

Default: 0

match_typestringopsional

Mode matching (c=case-sensitive, i=insensitive)

SQL

1 SELECT REGEXP_REPLACE('Hello! World?', '[^a-zA-Z0-9 ]', '') AS clean;

Menghapus karakter selain huruf, angka, dan spasi.

Hasil

clean: Hello World

SQL

1 SELECT REGEXP_REPLACE('08123456789', 
2   '(\\d{4})(\\d{4})(\\d+)', '\\1-\\2-\\3') AS formatted;

Memformat nomor telepon dengan dash.

Hasil

formatted: 0812-3456-789

SQL

1 SELECT REGEXP_REPLACE('Hello    World', '\\s+', ' ') AS normalized;

Mengganti multiple spaces dengan satu spasi.

Hasil

normalized: Hello World

1	SELECT REGEXP_REPLACE('08123456789',
2	'(\\d{4})(\\d{4})(\\d+)', '\\1-\\2-\\3') AS formatted;