How to check if field is null or empty in MySQL?

Either use

SELECT IF(field1 IS NULL or field1 = '', 'empty', field1) as field1 
from tablename

or use the following code, which I copied from another answer (by Himanshu) to this same question, at —

SELECT case when field1 IS NULL or field1 = ''
            then 'empty'
            else field1
       end as field1  from tablename

If you only want to check for null and not for empty strings then you can also use ifnull() or coalesce(field1, 'empty'). But that is not suitable for empty strings.

Leave a Comment