Try SELECT * FROM table ORDER BY col LIMIT 23 ;
If the col type is numeric, trying to match the string NULL might be the problem. And, if it is numeric, the NULL values will be listed first in 'ORDER BY col'. This doesn't really solve the problem of not being able to select 'where col is null', but should at least be of some use. Hope that helps, -Tom -----Original Message----- From: Deepak Vishwanathan [mailto:[EMAIL PROTECTED] Sent: Monday, July 19, 2004 11:14 AM To: [EMAIL PROTECTED] Subject: NULL problem Hi, I have a table with a column that has the Unique key constraint on it. In the table definition that column has a default NULL specification too. So, when I ran the query select * from table where col is NULL; I get only 1 row returned, when I have 23 such rows with NULL values. This might be because of the Unique Key constraint. Is there a query that will return all those 23 rows. Thanks, Deepak -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]