I am trying to find records where the value of a filed is NULL. I know that there are records that have null values but the result is always an empty set.

eg:
select test_id from tests where test_id=NULL

always returns an empty set when there are in fact records that have a null value for test_id. Is there some trick to finding null valued records in MySQL? This same sql has always worked on any other dbms I have used.

thanks
alan


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to