mysql length function

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

Posts to Review:

mysql concat function mysql locate function MySQL RAND Function MySQL trim function