String

CONCAT_WS

MySQL

Menggabungkan string dengan separator. WS artinya With Separator. Mengabaikan nilai NULL, berbeda dengan CONCAT biasa.

Tipe hasil: VARCHARDiperbarui: 7 Jan 2026

Syntax

SQL

CONCAT_WS(separator, str1, str2, ...)

separatorstringwajib

String pemisah antar nilai

str1, str2, ...stringwajib

String yang akan digabungkan

SQL

1 SELECT CONCAT_WS(', ', city, state, country) AS location
2 FROM addresses;

Menggabungkan lokasi dengan koma.

Hasil

location: Jakarta, DKI, Indonesia

SQL

1 SELECT CONCAT_WS('-', '2024', NULL, '01', '15') AS date_str;

NULL diabaikan, separator tidak ditambahkan.

Hasil

date_str: 2024-01-15

SQL

1 SELECT CONCAT_WS(',', id, name, email, phone) AS csv_row
2 FROM contacts;

Membuat baris CSV dari beberapa kolom.

Hasil

csv_row: 1,John,john@email.com,08123456

SQL

1 SELECT CONCAT_WS('/', base_path, folder, filename) AS full_path
2 FROM files;

Membangun path file dengan separator slash.

Hasil

full_path: /home/user/documents/file.txt

1	SELECT CONCAT_WS(', ', city, state, country) AS location
2	FROM addresses;

1	SELECT CONCAT_WS(',', id, name, email, phone) AS csv_row
2	FROM contacts;

1	SELECT CONCAT_WS('/', base_path, folder, filename) AS full_path
2	FROM files;