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 |