Mega Code Archive

 

Categories / MySQL Tutorial / String Functions

 

HEX(N_or_S)

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>