MySQL query WHERE length is longer than 1

I want to only show results where the length of a BLOB is greater then 1.

How do I find the length of a string in a MySQL query?

The LENGTH() function returns the length of a string (in bytes).

How do I find the longest word in MySQL?

Learn MySQL from scratch for Data Science and Analytics To get the longest varchar length, you need to use CHAR_LENGTH().

Can we use length function with where clause in MySQL?

The LENGTH() (MySQL) or LEN() (MSSQL) function will return the length of a string in a column that you can use as a condition in your WHERE clause.

How do I select a specific length in SQL?

To query for string fields with a specific length, use the char_length() or length() from MySQL.

Try this:

SELECT * FROM your_table
WHERE OCTET_LENGTH(blob_field) > 1

Related questions