LENGTH Function : LENGTH « String « SQL / MySQL






  1. SQL / MySQL
  2. String
  3. LENGTH

LENGTH Function

      
mysql>
mysql> SELECT LENGTH('cats and dogs');
+-------------------------+
| LENGTH('cats and dogs') |
+-------------------------+
|                      13 |
+-------------------------+
1 row in set (0.00 sec)








Related examples in the same category

1.LENGTH(RTRIM(SPACE(8)))
2.LENGTH(CONCAT(CAST(100000 AS CHAR(6)),'000'))
3.Length of trimmed varchar value
4.The length of the shortest verse in the King James Version, that's easy to find
5.Get cases name and length in the production dept
6.Preserving Trailing Spaces in String Columns
7.Determine how many bytes are necessary for storing the data.
8.Lists names from the names table with the longest names first