We help IT Professionals succeed at work.

Length of a blob field

Richard Korts
I'm trying to select all rows in a table where the length of one of the blob columns is > some number.

The column is called work_internal

Will this do it:

select * from workorder where length(work_internal) > xxx?

Watch Question

IT Manager
That should work just fine.  You might want to switch the comparison and see if a few small ones are returned before you dig for large ones.
select * from workorder where length(work_internal) < xxx

Open in new window

Richard KortsBusiness Owner / Chief Developer


I just did it with the > & it worked perfectly.

Incidentally, there are a total of 4 with the value I chose from over 96,000 rows.