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 th
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
Hi!
I've need to find the largest blobs in a table but I seem not to be able
to figure out what it is. Could anyone please help me with this?
Regards
Roland
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED
