The ELT SQL Function in MySQL and MariaDB - String at index |
|
| | ELT | Syntax: | ELT(Index, Strings ('str1','str2', ...)) | | Return value: | CHAR | | Function type: | String function | |
| | The ELT() function returns the character string corresponding to the specified position "Index" from a list of "Strings".
If "Index" is a floating point value, it is rounded to an integer.
Numeric values in the "Strings" list are interpreted as character strings.
If "Index" is less than 1 or rounded to 0, NULL, not a number, or greater than the total number of "Strings", the ELT() function returns NULL.
The ELT() function is complementary to the FIELD() function. | SQL Examples for the ELT function |
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
| select elt(1, 'Test1', 'Test2', 'Test3');
select elt(3, 'Test1', 'Test2', 'Test3');
select elt(5, 'Test1', 'Test2', 'Test3');
select elt(2, 123, 456, 789);
select elt(2, 'Test1', null, 'Test3');
select elt(3, 'Test1', null, 'Test3');
select elt(0.4, 'Test1', 'Test2', 'Test3');
select elt(0.6, 'Test1', 'Test2', 'Test3');
select elt(0, 'Test1', 'Test2', 'Test3');
select elt(null, 'Test1', 'Test2', 'Test3');
|
|
| elt(1, 'Test1', 'Test2', 'Test3') |
|---|
| varchar(5) BINARY |
|---|
| Test1 |
|
|
| elt(3, 'Test1', 'Test2', 'Test3') |
|---|
| varchar(5) BINARY |
|---|
| Test3 |
|
|
| elt(5, 'Test1', 'Test2', 'Test3') |
|---|
| varchar(5) BINARY |
|---|
| NULL |
|
|
| elt(2, 123, 456, 789) |
|---|
| varchar(3) BINARY |
|---|
| 456 |
|
|
| elt(2, 'Test1', null, 'Test3') |
|---|
| varchar(5) BINARY |
|---|
| NULL |
|
|
| elt(3, 'Test1', null, 'Test3') |
|---|
| varchar(5) BINARY |
|---|
| Test3 |
|
|
| elt(0.4, 'Test1', 'Test2', 'Test3') |
|---|
| varchar(5) BINARY |
|---|
| NULL |
|
|
| elt(0.6, 'Test1', 'Test2', 'Test3') |
|---|
| varchar(5) BINARY |
|---|
| Test1 |
|
|
| elt(0, 'Test1', 'Test2', 'Test3') |
|---|
| varchar(5) BINARY |
|---|
| NULL |
|
|
| elt(null, 'Test1', 'Test2', 'Test3') |
|---|
| varchar(5) BINARY |
|---|
| NULL |
|
|
| | The examples were created with the MyWAY SQL manager: | How to use the ELT() function in MySQL and MariaDB databases | | In MySQL and MariaDB the ELT() function is used to extract the string from a list of Return strings based on their index. The function is useful when, given a predefined list of strings, you want to retrieve a specific string based on its position or index. | | Further MySQL und MariaDB SQL String functions | | CHAR | CHAR(Character code, [, Charset]) | | More about CHAR Function |
| | CHR | CHR(Character code) | | More about CHR Function |
| | CONCAT | CONCAT(Strings ('str1','str2', ...)) | | More about CONCAT Function |
| | CONCAT_WS | CONCAT_WS(Separator, Strings ('str1','str2', ...)) | | More about CONCAT_WS Function |
| | EXPORT_SET | EXPORT_SET(Bits, On, Off [, Separator] [, Number of bits]) | | More about EXPORT_SET Function |
| | EXTRACTVALUE | EXTRACTVALUE(XML, XPath) |
| | FIELD | FIELD(Search string, Strings ('str1','str2', ...)) | | More about FIELD Function |
| | FORMAT | FORMAT(Number, Decimals [, Region]) | | More about FORMAT Function |
| | INSERT | INSERT(String, Position, Length, String to insert) | | More about INSERT Function |
| | LCASE | LCASE(String) | | More about LCASE Function |
| | LEFT | LEFT(String, Length) | | More about LEFT Function |
| | LOAD_FILE | LOAD_FILE(File name) |
| | LOWER | LOWER(String) | | More about LOWER Function |
| | LPAD | LPAD(String, Length, String to append) | | More about LPAD Function |
| | LPAD_ORACLE | LPAD_ORACLE(String, Length, String to append) | | More about LPAD_ORACLE Function |
| | LTRIM | LTRIM(String) | | More about LTRIM Function |
| | MAKE_SET | MAKE_SET(Bits, Strings ('str1','str2', ...)) | | More about MAKE_SET Function |
| | MID | MID(String, Position [, Length]) | | More about MID Function |
| | QUOTE | QUOTE(String) | | More about QUOTE Function |
| | REPEAT | REPEAT(String, Number) | | More about REPEAT Function |
| | REPLACE | REPLACE(String, Search, Replace) | | More about REPLACE Function |
| | REVERSE | REVERSE(String) | | More about REVERSE Function |
| | RIGHT | RIGHT(String, Length) | | More about RIGHT Function |
| | RPAD | RPAD(String, Length, String to append) | | More about RPAD Function |
| | RPAD_ORACLE | RPAD_ORACLE(String, Length, String to append) | | More about RPAD_ORACLE Function |
| | RTRIM | RTRIM(String) | | More about RTRIM Function |
| | SOUNDEX | SOUNDEX(String) | | More about SOUNDEX Function |
| | SPACE | SPACE(Number) | | More about SPACE Function |
| | SUBSTR | SUBSTR(String, Position, Length) | | More about SUBSTR Function |
| | SUBSTRING | SUBSTRING(String, Position, Length) | | More about SUBSTRING Function |
| | SUBSTRING_INDEX | SUBSTRING_INDEX(String, Delimiter, Number) | | More about SUBSTRING_INDEX Function |
| | TRIM | TRIM([Type] [, Delete character], , String) | | More about TRIM Function |
| | TRIM_ORACLE | TRIM_ORACLE([Type] [, Delete character], , String) | | More about TRIM_ORACLE Function |
| | UCASE | UCASE(String) | | More about UCASE Function |
| | UPPER | UPPER(String) | | More about UPPER Function |
| | WEIGHT_STRING | WEIGHT_STRING(String [AS Format] [LEVEL Level] [Sorting]) | | More about WEIGHT_STRING Function |
| | ASCII | ASCII(String) | | More about ASCII Function |
| | BIT_LENGTH | BIT_LENGTH(String) | | More about BIT_LENGTH Function |
| | CHAR_LENGTH | CHAR_LENGTH(String) | | More about CHAR_LENGTH Function |
| | CHARACTER_LENGTH | CHARACTER_LENGTH(String) | | More about CHARACTER_LENGTH Function |
| | FIND_IN_SET | FIND_IN_SET(Search string, Set of values) | | More about FIND_IN_SET Function |
| | INSTR | INSTR(String, Search string) | | More about INSTR Function |
| | LENGTH | LENGTH(String) | | More about LENGTH Function |
| | LENGTHB | LENGTHB(String) | | More about LENGTHB Function |
| | LOCATE | LOCATE(Search string, String [, Position]) | | More about LOCATE Function |
| | OCTET_LENGTH | OCTET_LENGTH(String) | | More about OCTET_LENGTH Function |
| | ORD | ORD(String) | | More about ORD Function |
| | POSITION | POSITION(Search string IN String) | | More about POSITION Function |
|
|
| | | More information about the ELT SQL function: and |
|
|
|
|
