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

Satya Prakash

VOIP Expert: More than 8 years of experience in Asterisk Development and Call Center operation Management. Unique Combination of Skill Set as IT, Analytics and operation management.

Leave a Reply