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.
Syntax:
ORD(str)
Argument:
Name | Description |
---|---|
str | A string. |
Syntax Diagram:

MySQL Version: 8.0
Example: MySQL ORD() function
The following MySQL statement returns 119.
Code:
SELECT ORD("w3resource");
Output:
mysql> SELECT ORD("w3resource"); +-------------------+ | ORD("w3resource") | +-------------------+ | 119 | +-------------------+ 1 row in set (0.00 sec)
Video Presentation:
All String Functions (Slides presentation)
Previous: OCTET_LENGTH
Next: POSITION
- Weekly Trends
- Python Interview Questions and Answers: Comprehensive Guide
- Scala Exercises, Practice, Solution
- Kotlin Exercises practice with solution
- MongoDB Exercises, Practice, Solution
- SQL Exercises, Practice, Solution - JOINS
- Java Basic Programming Exercises
- SQL Subqueries
- Adventureworks Database Exercises
- C# Sharp Basic Exercises
- SQL COUNT() with distinct
- JavaScript String Exercises
- JavaScript HTML Form Validation
- Java Collection Exercises
- SQL COUNT() function
- SQL Inner Join
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