You are viewing an older version of this section. View current production version.
Join the SingleStore Community Today
Get expert advice, develop skills, and connect with others.

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)