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 beginning the blob read : SELECT bin_data, filetype, filename, filesize FROM tbl_Files order by filesize desc; look at http://www.onlamp.com/pub/a/php/2000/09/15/php_mysql.html?page=1 to have a php blob manipulation sample. other languages like perl, asp, ado, ... do the same. hope that helps Mathias Selon Roland Carlsson <[EMAIL PROTECTED]>: > 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] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
