MySQL query to fetch column length declared with BLOB type

For this, use the LENGTH() function from MySQL. Let us first create a table. We have declared the type of column as BLOB −

mysql> create table DemoTable
(
   Title blob
);
Query OK, 0 rows affected (0.57 sec)

Insert some records in the table using insert command −

mysql> insert into DemoTable values('This is a MySQL tutorial');
Query OK, 1 row affected (0.18 sec)
mysql> insert into DemoTable values('Java is an object oriented programming language');
Query OK, 1 row affected (0.61 sec)
mysql> insert into DemoTable values('C is a procedural language');
Query OK, 1 row affected (0.20 sec)

Display all records from the table using select statement −

mysql> select *from DemoTable;

This will produce the following output −

+-------------------------------------------------+
| Title                                           |
+-------------------------------------------------+
| This is a MySQL tutorial                        |
| Java is an object oriented programming language |
| C is a procedural language                      |
+-------------------------------------------------+
3 rows in set (0.00 sec)

Following is the query to fetch column length declared with BLOB type using the LENGTH() method −

mysql> select length(Title) from DemoTable;

This will produce the following output −

+---------------+
| length(Title) |
+---------------+
|            24 |
|            47 |
|            26 |
+---------------+
3 rows in set (0.00 sec)