char_length function in MySQL queryWe can get length of the characters 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.
This article is written by plus2net.com team.