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

by

Either use

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

or

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.

More Related Contents:

  1. When using with SAVEPOINT and ROLLBACK , what will be the output of this?
  2. What’s the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN? [duplicate]
  3. How to find similar results and sort by similarity?
  4. Unknown column in ‘field list’ error on MySQL Update query
  5. Insert into multiple tables in one query
  6. generate_series() equivalent in MySQL
  7. MySQL : isn’t in GROUP BY
  8. MySQL: Can’t create table (errno: 150)
  9. Why does MySQL report a syntax error on FULL OUTER JOIN?
  10. Error creating table: You have an error in your SQL syntax near ‘order( order_id INT UNSIGNED NOT NULL AUTO_INCREMENT, user_id ‘ at line 1 [duplicate]
  11. Mixing ANSI 1992 JOINs and COMMAs in a query
  12. SQL: Creating a Relational table with 2 different auto_increment
  13. How do I add a custom CHECK constraint on a MySQL table?
  14. Order by COUNT per value
  15. Select from one table where not in another
  16. How to select the most recent set of dated records from a mysql table
  17. Second SELECT query if first SELECT returns 0 rows
  18. Set value to NULL in MySQL
  19. SELECT query return 1 row from each group
  20. MySql Single Table, Select last 7 days and include empty rows
  21. mysql SQL: specific item to be first and then to sort the rest of the items
  22. #1292 – Incorrect date value: ‘0000-00-00’ [duplicate]
  23. mysql count group by having
  24. SQL UPDATE with sub-query that references the same table in MySQL
  25. Equivalent of MySQL ON DUPLICATE KEY UPDATE in Sql Server
  26. How to store a one to many relation in MySQL database?
  27. MySQL – Complexity of: SELECT COUNT(*) FROM MyTable;
  28. How to count date difference excluding weekend and holidays in MySQL
  29. Execute multiple semi-colon separated query using mysql Prepared Statement
  30. mysql unique number generation

Leave a Comment