mysql LEN() function

English [leŋ] American [leŋ]

n.Length, long; the length of time; (language) sound length; a paragraph, a section

mysql LEN() functionsyntax

Function: Returns the length of the value in the text field.

Syntax: SELECT LEN(column_name) FROM table_name

mysql LEN() functionexample

//取得 "City" 列中值的长度
SELECT LEN(City) as LengthOfCity FROM Persons;