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, '') = ''

 

 

Feel free to comment if you can add help to this page or point out issues and solutions you have found. I do not provide support on this site, if you need help with a problem head over to stack overflow.

Comments

Your email address will not be published. Required fields are marked *