char_length function in MySQL queryWe can get length of the character present in a string by using char_lenght() function. Syntax
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.
We will get a list of id , name and length like this
Using char_length with WHERENow let us try to find some blank data in a numeric field ( mark )
We can combine two columns by using CONCAT() function and then find out the length of the total string.