bugl
bugl
HomeLearnPatternsSearch
HomeLearnPatternsSearch

Loading lesson path

Learn/SQL/SQL References
SQL•SQL References

MySQL LENGTH() Function

Concept visual

MySQL LENGTH() Function

Pointer walk
two pointers
leftright102132436485116
left=0
right=6
1
3

Start at both ends

Example

Return the length of the string, in bytes:

SELECT LENGTH("SQL Tutorial") AS LengthOfString;

Definition and Usage

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

Syntax

Length(

string )

Parameter Values

Parameter

Description string

Required. The string to count the length for

Technical Details

Works in:

From MySQL 4.0

More Examples

Example

Return the length of the text in the "CustomerName" column, in bytes:

SELECT LENGTH(CustomerName) AS LengthOfName

FROM Customers;

Previous

❮ MySQL Functions

Next

Previous

MySQL LEFT() Function

Next

MySQL LOCATE() Function