String

ELT

MySQL

Mengembalikan string ke-n dari daftar. ELT(1, 'a', 'b', 'c') = 'a', ELT(2, 'a', 'b', 'c') = 'b'.

Tipe hasil: VARCHARDiperbarui: 7 Jan 2026

Syntax

SQL

ELT(n, str1, str2, str3, ...)

nintegerwajib

Indeks string yang diinginkan (1-indexed)

str1, str2, ...stringwajib

Daftar string

SQL

1 SELECT ELT(2, 'a', 'b', 'c') AS result;

Mengambil elemen ke-2.

Hasil

result: b

SQL

1 SELECT ELT(status_code, 'Pending', 'Active', 'Completed') AS status
2 FROM orders;

Mengubah kode status menjadi teks.

Hasil

status: Active

SQL

1 SELECT ELT(DAYOFWEEK(order_date), 
2   'Minggu','Senin','Selasa','Rabu',
3   'Kamis','Jumat','Sabtu') AS day_name
4 FROM orders;

Mengubah nomor hari menjadi nama.

Hasil

day_name: Senin

1	SELECT ELT(status_code, 'Pending', 'Active', 'Completed') AS status
2	FROM orders;

1	SELECT ELT(DAYOFWEEK(order_date),
2	'Minggu','Senin','Selasa','Rabu',
3	'Kamis','Jumat','Sabtu') AS day_name
4	FROM orders;