How do I check if a column is empty or null in MySQL?

by

This will select all rows where some_col is NULL or '' (empty string)

SELECT * FROM table WHERE some_col IS NULL OR some_col="";

More Related Contents:

  1. Recreating a query using INNER JOIN? [duplicate]
  2. Create a Cumulative Sum Column in MySQL
  3. How to perform grouped ranking in MySQL
  4. Equivalent of explode() to work with strings in MySQL
  5. MySQL Trigger after update only if row has changed
  6. MySQL “WITH” clause
  7. mysql select dynamic row values as column names, another column as value
  8. MySQL “Group By” and “Order By”
  9. MySQL DELETE FROM with subquery as condition
  10. MySQL Query to select data from last week?
  11. SQL – IF EXISTS UPDATE ELSE INSERT INTO
  12. SELECT / GROUP BY – segments of time (10 seconds, 30 seconds, etc)
  13. Is it possible to query a tree structure table in MySQL in a single query, to any depth?
  14. Simple Random Samples from a Sql database
  15. How to convert number of week into date?
  16. The total number of locks exceeds the lock table size
  17. update multiple rows using limit in mysql?
  18. Mysql 1050 Error “Table already exists” when in fact, it does not
  19. How to get the latest record in each group using GROUP BY? [duplicate]
  20. How do I UPDATE a row in a table or INSERT it if it doesn’t exist?
  21. SQL unique varchar case sensitivity question
  22. How do I count columns of a table
  23. How to regex in a MySQL query
  24. Why MySQL is giving error “Not allowed to return a result set from a function”?
  25. MySQL 5.6 – DENSE_RANK like functionality without Order By
  26. Update MySQL with if condition
  27. “Unknown column in ‘field list'”, but column does exist
  28. How do I combine the results of two queries with ordering?
  29. ERROR 1115 (42000): Unknown character set: ‘utf8mb4’
  30. MYSQL Select One Random record from each Category

Leave a Comment