Did you try:
select blob_field
from blob_table
order by length(blob_field) DESC limit 1
Regards,
Artem
> -Original Message-
> From: Roland Carlsson [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, June 01, 2005 10:02 AM
> To: mysql@lists.mysql.com
> Subject: Find the biggest blobs
>
>
> H
Hi,
since reading blobs is not a simple action (heavy), you must store the size of
every file in the table's structure.
if you write with php, somthing like that filesize($binFile) gives you the
column value for every insert
When done, a simple order by filesize gives you what you want before beg
