select rows with column that is not null?

Question

by default i have one column in mysql table to be NULL.

i want to select some rows but only if the field value in that column is not NULL.

what is the correct way of typing it?

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

is this correct?

Answer 1

 AND name IS NOT NULL

(NULL comparisons require the special IS and IS NOT operator in SQL)

Answer 2

You should use (assuming $id is an integer):

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

You must use IS NULL or IS NOT NULL when working with NULL values

Answer 3

@Andy: my bad. I've only tested for columns' names.