Skip to main content

ELT

Returns the Nth element of the list of strings: str1 if N = 1, str2 if N = 2, and so on. Returns NULL if N is less than 1 or greater than the number of arguments. ELT() is the complement of FIELD().

Syntax​

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

Arguments​

ArgumentsDescription
NThe position.
strNThe string.

Return Type​

A string data type value.

Examples​

SELECT ELT(1, 'Aa', 'Bb', 'Cc', 'Dd');
+--------------------------------+
| ELT(1, 'Aa', 'Bb', 'Cc', 'Dd') |
+--------------------------------+
| Aa |
+--------------------------------+

SELECT ELT(4, 'Aa', 'Bb', 'Cc', 'Dd');
+--------------------------------+
| ELT(4, 'Aa', 'Bb', 'Cc', 'Dd') |
+--------------------------------+
| Dd |
+--------------------------------+