calculate length in mysql

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 … Read more