MySQL ORD() function

ORD() function

MySQL ORD() function 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) ...

This function is useful in -

  • Code value retrieval: It allows you to retrieve the numeric code value of the leftmost character in a string.
  • Character analysis: ORD() can be used for character analysis and identification purposes.
  • Sorting and ordering: ORD() can be used in sorting or ordering data based on the code values of characters.




Name Description
str A string.

Syntax Diagram:

MySQL ORD() Function - Syntax Diagram

MySQL Version: 8.0

Example: MySQL ORD() function

The following MySQL statement returns 119.


SELECT ORD("w3resource");


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

Video Presentation:

All String Functions (Slides presentation)


Follow us on Facebook and Twitter for latest update.

We are closing our Disqus commenting system for some maintenanace issues. You may write to us at reach[at]yahoo[dot]com or visit us at Facebook