MySQL ELT() Functions – String Functions

by · Published · Updated

MySQL ELT() Functions: Syntax

ELT ( N, string1, string2, ….. )

MySQL ELT() Functions: Description

ELT() functions returns the Nth element of the list of strings: string1 if N = 1, string2 if N = 2, and so on. You may have one or more arguments.

ELT() is the complement of FIELD().

MySQL ELT() Functions: Parameter

[table caption=”” width=”100%” colwidth=”15%|30%|55%” colalign=”left|left|left”]
Name, Required /Optional, Description
N, Required, The number of the element in the list which is to be returned.
string1, Required, first parameter is must.
string2 , Optional, second parameter is optional.
[/table]

MySQL ELT() Functions: Output

[table caption=”” width=”100%” colwidth=”20%|80%” colalign=”left|left”]
Returns,
NULL, if N is less than 1 or greater than the number of arguments.
List element, Specfied element in the string list.
[/table]

MySQL ELT() Functions: Available from

[table caption=”” width=”100%” colwidth=”25%|75%” colalign=”left|left”]
Version, MySQL 4.0
[/table]

 

MySQL ELT() Functions: Example 1

mysql> SELECT ELT(1,'Tutorial', 'mines', '.net') ;
+------------------------------------+
| ELT(1,'Tutorial', 'mines', '.net') |
+------------------------------------+
| Tutorial                           |
+------------------------------------+
1 row in set (0.00 sec)

mysql> SELECT ELT(3,'Tutorial', 'mines', '.net') ;
+------------------------------------+
| ELT(3,'Tutorial', 'mines', '.net') |
+------------------------------------+
| .net                               |
+------------------------------------+
1 row in set (0.00 sec)

mysql>  SELECT ELT(2,'Tutorial', 'mines', '.net') ;
+------------------------------------+
| ELT(2,'Tutorial', 'mines', '.net') |
+------------------------------------+
| mines                              |
+------------------------------------+
1 row in set (0.00 sec)

See all MySQL String functions MySQL 8 String Functions.

Related articles : LOCATE(), HEX(), CONCAT(), LOWER(), LTRIM(), INSTR(), POSITION(), FIELD().

PHP Related articles : IMPLODE(), STRRCHR(), STRRPOS(), PHP STRING FUNCTIONS(), STRRIPOS().

You may also like...