I want to query a database for a specific record that is NULL, here is what I have so far, and am getting nothing.

SELECT * FROM sp0405 WHERE Result = NULL

Viewing the records in PHPMyAdmin, the values are definately NULL.

I have used Result = '' in the past and have had it work, but this time I used the NULL value because I thought it was better coding. Is this possible to do?

    SELECT * 
    FROM sp0405
    WHERE Result is NULL
    
      Write a Reply...