String

REPLACE

MySQL

Mengganti semua kemunculan substring dengan string pengganti. Case-sensitive.

Tipe hasil: VARCHARDiperbarui: 7 Jan 2026

Syntax

SQL

REPLACE(str, from_str, to_str)

strstringwajib

String sumber

from_strstringwajib

Substring yang akan diganti

to_strstringwajib

String pengganti

SQL

1 SELECT REPLACE('Hello World', 'World', 'MySQL') AS result;

Mengganti 'World' dengan 'MySQL'.

Hasil

result: Hello MySQL

SQL

1 SELECT REPLACE(phone, '-', '') AS clean_phone
2 FROM contacts;

Menghapus tanda minus dari nomor telepon.

Hasil

clean_phone: 08123456789

SQL

1 SELECT LOWER(REPLACE(title, ' ', '-')) AS slug
2 FROM articles;

Mengubah spasi menjadi dash untuk URL slug.

Hasil

slug: my-article-title

SQL

1 SELECT REPLACE(REPLACE(text, '<', '&lt;'), '>', '&gt;') AS escaped
2 FROM content;

Escape HTML characters.

Hasil

escaped: <div>

1	SELECT REPLACE(phone, '-', '') AS clean_phone
2	FROM contacts;

1	SELECT LOWER(REPLACE(title, ' ', '-')) AS slug
2	FROM articles;

1	SELECT REPLACE(REPLACE(text, '<', '<'), '>', '>') AS escaped
2	FROM content;