mysql length function

Rate this post

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

For any query or issue, feel free to discuss on http://discuss.eduguru.in

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

Your email address will not be published. Required fields are marked *

%d bloggers like this: