How do I get the average string length in MySQL?

MySQLMySQLi Database

To get the average string length in MySQL, we will work around a query that gets rows from 1 to 10 and displays the result.

Let us first create a table. The query to create a table is as follows −

mysql> create table AverageString
   -> (
   -> Id int NOT NULL AUTO_INCREMENT PRIMARY KEY,
   -> Value varchar(20)
   -> );
Query OK, 0 rows affected (0.66 sec)

Insert some records in the table using insert command. The query is as follows −

mysql> insert into AverageString(Value) values('MySQL Query');
Query OK, 1 row affected (0.18 sec)
mysql> insert into AverageString(Value) values('SQL Server Query');
Query OK, 1 row affected (0.17 sec)

Display all records from the table using select statement. The query is as follows −

mysql> select *from AverageString;

Output

+----+------------------+
| Id | Value            |
+----+------------------+
|  1 | MySQL Query      |
|  2 | SQL Server Query |
+----+------------------+
2 rows in set (0.00 sec)

The query is as follows to get average string length −

mysql> select avg(length(Value)) from AverageString limit 10;

Output

+--------------------+
| avg(length(Value)) |
+--------------------+
|            13.5000 |
+--------------------+
1 row in set (0.00 sec)
raja
Published on 19-Mar-2019 12:22:37
Advertisements