Select rows with a column that is not null?

Question

by default I have one column in the mysql table is NULL.

I want to select multiple rows, but only if the field value in this column is not NULL.

What is the correct way to enter it?

    $query = "SELECT *
            FROM names
            WHERE id = '$id'
            AND name != NULL";

Is it correct?

Answer 1

You should use (if $id- an integer):

   $query = "SELECT *
            FROM names
            WHERE id = '" . (int) $id ."'
            AND name IS NOT NULL";

You should use IS NULLor IS NOT NULLwhen working with null values

Answer 2

 AND name IS NOT NULL

(for comparison, NULL requires a special IS and IS NOT-statement in SQL)