Tutorial Gateway

MySQL ELT Function

by

MySQL ELT one of the String Function, which will return the string expression (or string value) at the index position specified in the first argument. In this article we will show you, How to write String ELT function in MySQL with example.

MySQL ELT Syntax

The basic syntax of String ELT in MySQL is as shown below:

SELECT ELT (Value, Str1, Str2,....,StrN)
FROM Source

From the above String ELT function in MySQL will return Str1 to StrN based on the index position given at Value argument. For example, ELT(2, ‘Hi’, ‘Hello’) return Hello as the output.

MySQL ELT Example 1

The String ELT function in MySQL is used to return the string at specified position. The following query will show you multiple ways to use this ELT function.

-- MySQL String ELT Function Example
SELECT ELT(1, 'Learn', 'MySQL', 'Tutorial', 'at', 'tutorialgateway.org');

SELECT ELT(3, 'Learn', 'MySQL', 'Tutorial', 'at', 'tutorialgateway.org');

SELECT ELT(5, 'Learn', 'MySQL', 'Tutorial', 'at', 'tutorialgateway.org');

SELECT ELT(5, 'Learn', 'MySQL', 'Tutorial');

SELECT ELT(-2, 'Learn', 'MySQL', 'Tutorial');

OUTPUT

MySQL ELT Function Example 1

Let me show you, what will happen, if we specify NULL values as the arguments.

-- MySQL String ELT Function Example
SELECT ELT('2', 'Learn', 'MySQL', 'Tutorial');

SELECT ELT(2, 'Learn', NULL, 'MySQL', 'Tutorial');

SELECT ELT(NULL, 'Learn', NULL, 'MySQL', 'Tutorial');

OUTPUT

MySQL ELT Function Example 2

Thank You for Visiting Our Blog