How to retrieve the string at a given index in a string list using the ELT() function?

ELT(N, str1, str2, ...) is a MySQL built-in function that returns the string at a given index in a string list. For example:

SELECT ELT(3, 'Orange', 'Banana', 'Apple');
  -- +-------------------------------------+
  -- | ELT(3, 'Orange', 'Banana', 'Apple') |
  -- +-------------------------------------+
  -- | Apple                               |
  -- +-------------------------------------+

Reference information of the ELT() function:

ELT(N, str1, str2, ...): str
  Returns the Nth element of the list of strings: str1 if N = 1, str2 if
  N = 2, and so on. Returns NULL if N is less than 1, greater than the
  number of arguments, or NULL.

Arguments, return value and availability:
  N: Required. The index in the string list.
  str1, str2, ...: One or more strings to form the string list.
  str: Return value. The string at the given index in the string list.
  Available since MySQL 4.0.

Related MySQL functions:

• FIELD() - Find String in String List
• FIND_IN_SET() - Find Substring in List String

⇒ FIELD() - Find String in String List

⇐ CONV() - Binary/HEX String and Integer Conversion

⇑ MySQL Functions on Character String Values

⇑⇑ MySQL Function References