Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query optimization, and usability that you won’t want to miss.

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)