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)

Was this Article Helpful?

Thanks For Your Feedback!