MYSQL Tutorial

MySQL ORD() function

ORD() function

MySQL ORD() returns the code for the leftmost character if that character is a multi-byte (sequence of one or more bytes) one. If the leftmost character is not a multi-byte character, ORD() returns the same value as the ASCII() function.

The formula to calculate the numeric values of its constituent bytes is :

(1st byte code) + (2nd byte code * 256) + (3rd byte code * 2562) ...




Name Description
str A string.

Syntax Diagram:

MySQL ORD() Function - Syntax Diagram

MySQL Version: 5.6

Video Presentation

Example: MySQL ORD() function

The following MySQL statement returns 119.


SELECT ORD("w3resource");

Sample Output:

mysql> SELECT ORD("w3resource"); 
| ORD("w3resource") |
|               119 | 
1 row in set (0.00 sec)

All String Functions

MySQL String Functions, slide presentation

New Content: Composer: Dependency manager for PHP, R Programming