{"id":11025,"date":"2023-10-12T17:52:01","date_gmt":"2023-10-13T00:52:01","guid":{"rendered":"https:\/\/www.mysqltutorial.org\/?page_id=11025"},"modified":"2023-10-12T21:23:20","modified_gmt":"2023-10-13T04:23:20","slug":"mysql-ascii","status":"publish","type":"page","link":"https:\/\/www.mysqltutorial.org\/mysql-string-functions\/mysql-ascii\/","title":{"rendered":"MySQL ASCII() Function"},"content":{"rendered":"\n

Summary<\/strong>: in this tutorial, you will learn how to use the MySQL ASCII()<\/code> function to get the ASCII<\/code> code of a character.<\/p>\n\n\n\n

Introduction to MySQL ASCII function<\/h2>\n\n\n\n

ASCII stands for American Standard Code for Information Interchange. It is a character encoding standard representing text and control characters using numeric values. <\/p>\n\n\n\n

Since ASCII uses 7-bit binary code to represent characters, it can have 128 characters. In ASCII, each character is assigned a unique number ranging from 0 to 127. For example, the decimal value for the letter ‘A’ is 65.<\/p>\n\n\n\n

In MySQL, the ASCII function returns a number value of the first character of a string. The following shows the syntax of the ASCII function:<\/p>\n\n\n

ASCII(string)<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
In this syntax, the string is the character or string for which you want to find the ASCII<\/code> value. If the string is null, the ASCII returns NULL<\/code>.<\/p>\n\n\n\n
MySQL ASCII function examples<\/h2>\n\n\n\n
Let’s take some examples of using the ASCII()<\/code> function.<\/p>\n\n\n\n
1) Getting ASCII of a single character<\/h3>\n\n\n\n
The following example uses the ASCII()<\/code> function to get the ASCII code of the character ‘A’:<\/p>\n\n\n
SELECT<\/span> ASCII<\/span>('A'<\/span>);<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Output:<\/p>\n\n\n
+------------+<\/span>\n| ASCII('A') |\n+------------+<\/span>\n|         65 |\n+------------+<\/span>\n1 row in set<\/span> (0.00<\/span> sec)<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
The ASCII<\/code> code of the letter ‘A’ is 65.<\/p>\n\n\n\n
2) Getting ASCII of the leftmost character of a string<\/h3>\n\n\n\n
If you pass a string that contains multiple characters, the ASCII()<\/code> function will return the ASCII code of the leftmost character for example:<\/p>\n\n\n
SELECT<\/span> \n  ASCII<\/span>('MySQL'<\/span>);<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Output:<\/p>\n\n\n
+----------------+<\/span>\n| ASCII('MySQL') |\n+----------------+<\/span>\n|             77 |\n+----------------+<\/span>\n1 row in set<\/span> (0.00<\/span> sec)<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
In this example, the ASCII<\/code> function returns the ASCII code of the letter M in the string MySQL.<\/p>\n\n\n\n
3) Using the ASCII function with table data<\/h3>\n\n\n\n
We’ll use the products<\/code> table in the sample database<\/a> for the demonstration:<\/p>\n\n\n\n
\"MySQL<\/figure>\n\n\n\n
The following example uses the ASCII<\/code> function to find the products whose names have the first character with the ASCII<\/code> code greater than 66:<\/p>\n\n\n
SELECT<\/span> \n  productName \nFROM<\/span> \n  products \nWHERE<\/span> \n  ASCII<\/span>(productName) > 66<\/span>;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Output:<\/p>\n\n\n
+----------------------------------+<\/span>\n| productName                      |\n+----------------------------------+<\/span>\n| P-51-D Mustang                   |\n| Collectable Wooden Train         |\n| Corsair F4U ( Bird Cage)         |\n| Diamond T620 Semi-Skirted Tanker |\n| The Schooner Bluenose            |\n| The Mayflower                    |\n| HMS Bounty                       |\n| The USS Constitution Ship        |\n| F\/A 18 Hornet 1\/72               |\n| The Titanic                      |\n| The Queen Mary                   |\n| Pont Yacht                       |\n+----------------------------------+<\/span>\n12 rows in set<\/span> (0.02<\/span> sec)<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Summary<\/h2>\n\n\n\n
    \n
  • Use the MySQL ASCII<\/code>() function to find the ASCII<\/code> code of the leftmost character of a string.<\/li>\n<\/ul>\n
    \n\t
    \n\t\t
    Was this tutorial helpful? <\/div>\n\t\t
    \n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t Yes <\/span>\n\t\t\t<\/button>\n\n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t No <\/span>\n\t\t\t<\/button>\n\t\t<\/div>\n\t<\/header>\n\n\t
    \n\t\t
    \n\t\t\t
    <\/div>\n\t\t\t\n\t\t\t