Null or Empty Strings

An empty field can be either an empty string or a NULL.

Is field is not empty AND not null (i.e. it has an actual string in it):

WHERE field_name > ''

Is field is empty OR null:

WHERE IFNULL(field_name, '') = ''