When you need to find rows with null values in a MySQL table, you can use the _____.
A) SELECT NULL command
B) GROUP BY NULL condition
C) = NULL condition
D) IS NULL operator

Question

Quizplus · Accepted Answer

The correct way to find rows with null values in a MySQL table is to use the "IS NULL" operator. The "= NULL" condition does not work for checking null values because in SQL, NULL is not equal to anything, including itself; hence, the "IS NULL" operator must be used.

When You Need to Find Rows with Null Values in a MySQL