CHAR_LENGTH

Provide the length of the string.

SELECT CHAR_LENGTH(“SQL Tutorial”) AS LengthOfString;

Definition and Usage

The CHAR_LENGTH() function retrieves the length of a string in characters.

Note: This function is equivalent to the CHARACTER_LENGTH() function.

CHAR_LENGTH(string)

Parameter	Description
string	Mandatory. Specifies the string for which to determine the length.

Works in:

From MySQL 4.0

Retrieve the length of the text within the “CustomerName” column.

SELECT CHAR_LENGTH(CustomerName) AS LengthOfName
FROM Customers;