mysql 5.7

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;

Tablenames Records
Customers 91
Categories 8
Employees 9
OrderDetails 2155
Orders 830
Products 77
Shippers 3
Suppliers 29