ELT()

ELT() is a SQL function in the String Functions category. Returns the string at the specified index from a list. MySQL-specific. Inverse of FIELD(). The syntax is ELT(index, string1, string2, ...). It accepts index, string1, string2, .... It returns string at index. A typical example: SELECT ELT(3, 'Low', 'Medium', 'High', 'Critical'); -- 'High' A close relative is CONCAT(), which concatenates two or more strings into one string. Returns NULL if any argument is NULL. A close relative is SUBSTRING(), which extracts characters from a string starting at position `start` for `length` characters. A close relative is REPLACE(), which replaces all occurrences of `from_string` with `to_string` in a string. More about this category: String manipulation — CONCAT, SUBSTRING, REPLACE, TRIM, UPPER, LOWER, LENGTH. Related String Functions entries: CONCAT(), SUBSTRING(), REPLACE(), LENGTH(), TRIM(), UPPER(), LOWER(), LPAD() / RPAD(). This page is part of the free SQL Reference documentation covering 762+ statements, functions, and clauses, each with syntax, parameters, return values, and examples for MySQL, PostgreSQL, SQL Server, and SQLite.