How to convert an integer from one number base to another using the CONV() function?

CONV(str, from_base, to_base) is a MySQL built-in function that converts an integer from one number base to another. For example:

SELECT CONV(1279, 10, 16), CONV('4FF', 16, 10);
  -- +--------------------+---------------------+
  -- | CONV(1279, 10, 16) | CONV('4FF', 16, 10) |
  -- +--------------------+---------------------+
  -- | 4FF                | 1279                |
  -- +--------------------+---------------------+

SELECT CONV(1279, 10, 8), CONV('2377', 8, 10);
  -- +-------------------+---------------------+
  -- | CONV(1279, 10, 8) | CONV('2377', 8, 10) |
  -- +-------------------+---------------------+
  -- | 2377              | 1279                |
  -- +-------------------+---------------------+

SELECT CONV(1279, 10, 2), CONV('10011111111', 2, 10);
  -- +-------------------+----------------------------+
  -- | CONV(1279, 10, 2) | CONV('10011111111', 2, 10) |
  -- +-------------------+----------------------------+
  -- | 10011111111       | 1279                       |
  -- +-------------------+----------------------------+

Reference information of the CONV() function:

CONV(str, from_base, to_base): mewstr
  converts an integer from one number base to another.

Arguments, return value and availability:
  str: Required. The integer string in from_base base.
  mewstr: Return value. The converted integer string to_base base.
  Available since MySQL 4.0.

Related MySQL functions:

• BIN() - Converting Integer to Binary String
• CONV() - Number Base Conversion

⇒ COS() - Cosine Trigonometric Value

⇐ CEILING() - Rounding up to Integer

⇑ MySQL Functions on Numeric Values

⇑⇑ MySQL Function References