How find null values in MySQL

You can use IS NULL in a SELECT query to find null values.

SELECT * FROM your_table WHERE your_column IS NULL;

To search non-null values use IS NOT NULL.

SELECT * FROM your_table WHERE your_column IS NOT NULL;