char_length query to get the number of characters present inside a string.

We can get length of the characters present in a string by using char_lenght() function. Syntax

CHAR_LENGTH('string');

Example

SELECT CHAR_LENGTH('plus2net.com');

The output is 12
We will apply this to our student table
Let us find out the length of name present in our student table.

SELECT id, name, char_length(name) as LN FROM `student`

We will get a list of id , name and length like this

id	name	LN
1	John Deo	8
2	Max Ruin	8
3	Arnold	6

We have seen how to use char_length in SELECT queries. Now let us use them inside WHERE Query

Using char_length with WHERE

Now let us try to find some blank data in a numeric field ( mark )

SELECT id, name FROM `student` WHERE char_length(mark) <=1

We can combine two columns by using CONCAT() function and then find out the length of the total string.

SELECT id,CONCAT(name,'-',class) as Name , 
 CHAR_LENGTH(CONCAT(name,'-',class) ) as LN FROM `student`

Few rows are shown here.

id	Name	LN
1	John Deo-Four	13
2	Max Ruin-Three	14
-	--	--
34	Gain Toe-Seven	14
35	Rows Noump-Six	14
39	-	1

SQL String References SQL to get length of string substring_index to get part of string using delimiter

Subhendu Mohapatra

Author & Instructor at plus2net

I write and maintain practical tutorials on Python, PHP, SQL, JavaScript, HTML, jQuery, and web development at plus2net. The tutorials focus on clear explanations, working examples, and code that readers can test and adapt while learning.

About the author Watch on YouTube

Connect:

Subscribe to our YouTube Channel here

char_length function in MySQL query

Using char_length with WHERE

Subhendu Mohapatra