Is it possible to create a sql statement that selects all rows except rows where a specific field is empty?
SELECT * FROM table WHERE field IS NOT NULL
... depends on what you define as 'empty' empty can be NULL, but also a zero-length string: ""
Different database treat these differently.
Right you are. Attribute the omission to fatigue. 🙂
actually, it's probably a zero-length string: "". It's a MySQL database and the field type is BLOB. so in actuality i don't think that the field is NULL.
