Description:
MySQL LENGTH() returns the length of a given string.
Syntax:
LENGTH (str)
Argument:
Name Description
str A string whose length is to be returned.
Example of MySQL LENGTH() function
mysql> SELECT LENGTH(NULL);
Result: NULL
mysql> SELECT LENGTH(”);
Result: 0
mysql> SELECT LENGTH(‘ ‘);
Result: 1
mysql> SELECT LENGTH(‘satya prakash’);
Result: 13
mysql> SELECT LENGTH(‘blog.eduguru.in’);
Result: 15