MySQL Char_Length one of the String Function, which returns the length of the user specified string measured in characters. This function will consider the multi byte character as the single character. And this is the major difference between Char_Length and Length function.
TIP: In MySQL, Character_length is the synonyms for the standard Char_Length function. So, you can use any of these function names
MySQL Char_Length Syntax
The basic syntax of Character_Length in MySQL is as shown below:
|
1 2 |
SELECT LENGTH (String_Expression) FROM Source |
In this article we will show you, How to write MySQL Character_Length Function using Command Prompt, and Workbench with example. For this, we are going to use the below shown data
MySQL Char_Length Example 1
The char length function is used to count the number of single characters inside a specified expression. The following query will show you multiple ways to use this character length function.
|
1 2 3 4 5 6 |
-- MySQL Character Length Example SELECT CHAR_LENGTH ('MySQL') AS `Char Length`; SELECT CHAR_LENGTH ('Learn MySQL Tutorials') AS `MySQL Length`; SELECT CHAR_LENGTH ('Tutorial Gateway') AS `Website Length`; |
Remember, Char_Length function will count the empty space as well.
MySQL Char_Length Example 2
The char_length function also allows you to find the character length of the data inside a column. In this example, we are going to find the charcater length of two columns: Department Name, and Email column.
|
1 2 3 4 5 6 7 8 9 |
-- MySQL Character_Length Example USE mysqltutorial; SELECT FirstName, LastName, DepartmentName, CHAR_LENGTH(DepartmentName) AS `Char Length of Dept`, Email, CHARACTER_LENGTH(Email) AS `Char Length of Email` FROM employe; |
OUTPUT
MySQL Char_Length Function – WHERE Condition
In this example we will show you, How to use Character length function at where condition. Here, we used the char_length function in where clause to check whether the character length of a department column data is greater than 7 or not.
|
1 2 3 4 5 6 7 8 9 10 11 |
-- MySQL Character_Length Example USE mysqltutorial; SELECT FirstName, LastName, DepartmentName, CHAR_LENGTH(DepartmentName) AS `Char Length of Dept`, Email, CHARACTER_LENGTH(Email) AS `Char Length of Email` FROM employe WHERE CHAR_LENGTH(DepartmentName) > 7 ORDER BY `Char Length of Dept`; |
Remember, WHERE Clause does not understand the ALIAS Column name declared in the SELECT Statement. So, you have to use Character_Length function explicitly at where clause
Thank You for Visiting Our Blog
Share your Feedback, or Code!!