ELT
On this page
Returns the Nth value in its list of arguments.
Syntax
ELT (pos, val, [val, [val...]])
Arguments
-
pos: one-indexed argument position
-
val: any number of values.
Remarks
-
The function returns
NULLifposis less than 1 or greater than the number of values specified as arguments.
Examples
SELECT ELT(2, 'foo', 'bar', 'baz') AS Result;
+-----------------------------+
| Result |
+-----------------------------+
| bar |
+-----------------------------+SELECT ELT(0, 'housewares', 'textiles', 'appliances', 'lamps') AS Product_Type;
+------------------------------+
| Product_Type |
+------------------------------+
| NULL |
+------------------------------+
1 row in set (295 ms)SELECT ELT(5, 'name', 'code', 'location') AS Company_Details;
+------------------------------+
| Company_Details |
+------------------------------+
| NULL |
+------------------------------+
1 row in set (320 ms)Last modified: February 24, 2023