char_length function in MySQL query

We can get length of the character 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
1John Deo8
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`
    Visitors Rating
    Your Rating




  • Post Comment This is for short comments only. Use the forum for more discussions.








    HTML MySQL PHP JavaScript ASP Photoshop Articles FORUM . Contact us
    ©2000-2019 plus2net.com All rights reserved worldwide Privacy Policy Disclaimer