摘要:
下文讲述MySQL数据库中系统函数ORD(str)的功能简介说明,如下所示;
ORD函数功能说明:
如果字符串最左边是一个多字节字符,则返回第一个字符所对应的ASCII码,
此时ORD函数同ASCII函数具有相同的功能。
ORD函数举例说明:
mysql> select ord('m'),ascii('m');
+----------+------------+
| ord('m') | ascii('m') |
+----------+------------+
| 109 | 109 |
+----------+------------+
1 row in set (0.03 sec)
mysql> select ord('maomao365.com'),ascii('maomao365.com');
+----------------------+------------------------+
| ord('maomao365.com') | ascii('maomao365.com') |
+----------------------+------------------------+
| 109 | 109 |
+----------------------+------------------------+
1 row in set (0.00 sec)
mysql> select ord('猫猫教程');
+---------------------+
| ord('猫猫教程') |
+---------------------+
| 231 |
+---------------------+
1 row in set (0.00 sec)
mysql> select ord('猫猫');
+----------------+
| ord('猫猫') |
+----------------+
| 231 |
+----------------+
1 row in set (0.00 sec)
mysql> select ord('猫猫');
+---------------+
| ord('猫猫') |
+---------------+
| 231 |
+---------------+
1 row in set (0.00 sec)
mysql> select ord('猫');
+-------------+
| ord('猫') |
+-------------+
| 231 |
+-------------+
1 row in set (0.00 sec)