ORD() - Order Value of First Character

Q

How to calculate the order value of the first character in a string using the ORD() functions?

✍: FYIcenter.com

A

ORD(str, pos, len) is a MySQL built-in function that order value of the first character of a giving string. For example:

SELECT ORD("dba.FYIcenter.com");
  -- +--------------------------+
  -- | ORD("dba.FYIcenter.com") |
  -- +--------------------------+
  -- |                      100 |
  -- +--------------------------+

SELECT ORD('O'), ORD('©'), ORD('😋');
  -- +----------+-----------+-------------+
  -- | ORD('O') | ORD('©')  | ORD('😋')     |
  -- +----------+-----------+-------------+
  -- |       79 |     49833 |         240 |
  -- +----------+-----------+-------------+

SELECT HEX('O'), HEX('©'), HEX('😋');
  -- +----------+-----------+-------------+
  -- | HEX('O') | HEX('©')  | HEX('😋')     |
  -- +----------+-----------+-------------+
  -- | 4F       | C2A9      | F09F988B    |
  -- +----------+-----------+-------------+

Reference information of the ORD() function:

ORD(str): int
  If the leftmost character of the string str is a multibyte character,
  returns the code for that character, calculated from the numeric
  values of its constituent bytes using this formula:
      (1st byte code)
    + (2nd byte code * 256)
    + (3rd byte code * 256^2) ...

  If the leftmost character is not a multibyte character, ORD() returns
  the same value as the ASCII() function.

Arguments, return value and availability:
  str: Required. The given string to be calculated on
  int: Return value. The order value of the first character.
  Available since MySQL 5.7.

Related MySQL functions:

 

POSITION() - Synonym for LOCATE()

OCTET_LENGTH() - Synonym for LENGTH()

MySQL Functions on Character String Values

⇑⇑ MySQL Function References

2023-11-13, 233🔥, 0💬