MySQL ELT Function

MySQL ASCII is one of the String Function, which returns the ASCII code of the left most character of a character expression. In this article we will show you, How to use this string ASCII in MySQL with example.

MySQL ASCII Syntax

The basic syntax of the ASCII Function in MySQL is as shown below:

1 2	SELECT ASCII (Expression) FROM [Source]

Expression: Please specify a valid Expression for which you want to find the ASCII code. If the specified expression is more than one character then, ASCII Function will return the ASCII code of a left most character of the expression.

TIP: Please refer ASCII Table to check the ASCII values for each and every character.

In order to demonstrate this string function, We are going to use the customerdetails table data that we shown below

MySQL ASCII Example 1

The ASCII Function in MySQL is used to return the ASCII code of the leftmost character in an expression. The following query will show multiple ways to use this function.

SELECT ASCII('A');

SELECT ASCII(1);

SELECT ASCII('abcd');

SELECT ASCII('');

SELECT ASCII(NULL);

OUTPUT

MySQL ASCII Function Example 2

In this example, we are going to implement the string ASCII function on different columns in a table. Following statement will return the ASCII code of leftmost character in First_Name, Last_Name, and Yearly_Income column.

-- MySQL String ASCII Example

USE company;

SELECT First_Name,

ASCII(First_Name) AS ASCII_FName,

Last_Name,

ASCII(Last_Name) AS ASCII_LName,

Education,

Profession,

Yearly_Income,

ASCII(Yearly_Income) AS ASCII_Income,

Sales

FROM customerdetails;

From the below screenshot you can observe that, 84 is the ASCII code of T, and 57 is the ASCII code of 9

Thank You for Visiting Our Blog 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:

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

From the above ELT function 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 ELT function 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

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

Thank You for Visiting Our Blog

MySQL ASCII Syntax

MySQL ASCII Example 1

MySQL ASCII Function Example 2

MySQL ELT Syntax

MySQL ELT Example 1

Leave a Reply Cancel reply