SQL•SQL References

MySQL LENGTH() Function

Example

SELECT LENGTH("SQL Tutorial") AS LengthOfString;

Definition and Usage

The LENGTH() function returns the length of a string (in bytes).

Syntax

LENGTH(
string
)

Parameter	Description
string	Required. The string to count the length for

Works in:	From MySQL 4.0

Loading lesson path

SQL•SQL References

Example

SELECT LENGTH("SQL Tutorial") AS LengthOfString;

The LENGTH() function returns the length of a string (in bytes).

Syntax

LENGTH(
string
)

Parameter	Description
string	Required. The string to count the length for

Works in:	From MySQL 4.0