HEX(N_or_S) : HEX « String Functions « MySQL Tutorial

1. MySQL Tutorial
2. String Functions
3. HEX

If N_or_S is a number, returns a string representation of the hexadecimal value of N.

If N_or_S is a string, returns a hexadecimal string representation of N_or_S where each character in N_or_S is converted to two hexadecimal digits.

mysql>
mysql> SELECT HEX(255);
+----------+
| HEX(255) |
+----------+
| FF       |
+----------+
1 row in set (0.00 sec)

mysql>