PHP mysql WHERE length is longer than 1

Question

So, I want to show only the results when the BLOB length is greater than 1.

I was wondering if anyone could help

+5

Russell Harrower Oct 25 '11 at 11:12

1 answer

Marco · Accepted Answer · 2011-10-25T11:15:03+0000

Try the following:

SELECT * FROM your_table
WHERE OCTET_LENGTH(blob_field) > 1