Tutorial Gateway

MySQL HEX Function

by

MySQL HEX function is one of the String Function which is used to convert the given value to Hexadecimal number, and returns the string representation of that Hexadecimal number.

In this article, we will show you, How to use this string HEX in MySQL with example.

MySQL HEX Syntax

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

SELECT HEX(N)

SELECT HEX(String_Value);

MySQL Hexadecimal Function Example

The Hexadecimal Function in MySQL converts the user specified number or String to Hexadecimal Number. Next, it returns the Output in String format. The following query shows you multiple ways to use this HEX function on Numeric values.

SELECT HEX(10);

SELECT HEX(2500);

SELECT HEX(1900), HEX(34567890);

OUTPUT

MySQL HEX Function 1

Let me take another example to show the HEX(String). If we specify the string value as the HEX argument then this function converts each byte of a character in a string into a hexadecimal digit.

SELECT HEX('Hi');

SELECT HEX('Tutorial Gateway');

SELECT HEX('MySQL');

OUTPUT

MySQL HEX Function 2

Thank You for Visiting Our Blog