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

char_length function in MySQL query

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

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.

This article is written by plus2net.com team. https://www.plus2net.com

plus2net.com