mysql - size of field (kb) - PHPBuilder Forums

mysql - size of field (kb)

mod_frank

I have an article manager and I want to display the size of the article in kb. I do not know how to achieve this. A point in the right direction can help... The body (which I want to get the size of) is stored in the field named body of type longtext.

Thanks,
-mod_frank

tserbis

try
SELECT ..., ROUND(LENGTH(fieldname)/1024) as len FROM ...

mod_frank

thanks...