Collections:
ORD() - Order Value of First Character
How to calculate the order value of the first character in a string using the ORD() functions?
✍: FYIcenter.com
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()
2023-11-13, 236🔥, 0💬
Popular Posts:
How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...
How To Start Instance with a Minimal Initialization Parameter File in Oracle? The sample initializat...
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...
How To Query Tables and Loop through the Returning Rows in MySQL? The best way to query tables and l...