mysql length function : calculate length of a column

mysql length function : calculate length of a column

Function length()

  • Return the length of the string

Usages

SELECT CustomerName, LENGTH(CustomerName) AS LengthOfName FROM Customers;

TablenamesRecords
Customers91
Categories8
Employees9
OrderDetails2155
Orders830
Products77
Shippers3
Suppliers29