[RESOLVED] BLOB value in WHERE cluase?

[fuzzy1]

Hey All,

Trying to sort out a way to verify blob data has been uploaded (php)

WHERE blob_field IS NOT NULL

works fine while blob_field value = [BLOB - NULL], but what about when blob_field value= [BLOB - 0 Bytes] or something less than... say -- 200kb???

[bradgrafelman]

SELECT * FROM `myTable` WHERE OCTET_LENGTH(`blob_field`) >= 200*1024

Shows rows only where the blob field is greater than or equal to 200KB.

[fuzzy1]

THAT... is a beeeautiful thing! Perfect even! 😃 😃 😃
Gawd I DO love the forums!

Many Thanks Brad! Many Thanks!