ELT

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 NULL if pos is 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

Was this article helpful?