How to calculate the hexadecimal representation of a given string or integer using the HEX() function?

HEX(in) is a MySQL built-in function that calculates the hexadecimal representation of a given string or integer. For example:

SELECT HEX('FYI'), HEX(255);
  -- +------------+----------+
  -- | HEX('FYI') | HEX(255) |
  -- +------------+----------+
  -- | 465949     | FF       |
  -- +------------+----------+

Reference information of the HEX() function:

HEX(in): hex
  For a string argument, HEX() returns a hexadecimal string
  representation where each byte of each character in input string is
  converted to two hexadecimal digits.

  For a numeric argument, HEX() returns a hexadecimal string
  representation of the input treated as a longlong (BIGINT) number.
  This is equivalent to CONV(in, 10, 16)

Arguments, return value and availability:
  in: Required. The input string or integer.
  hex: Return value. The hexadecimal string representation of the input.
  Available since MySQL 5.7.

Related MySQL functions:

• UNHEX() - HEX to String Conversion

⇒ INSERT() - Insert and Replace Substring

⇐ FROM_BASE64() - Base64 Decoding

⇑ MySQL Functions on Character String Values

⇑⇑ MySQL Function References