Hello;
DELETE FROM table_name WHERE 1 ;
This command will remove all rows from the table.
For more information, see:
http://dev.mysql.com/doc/mysql/en/DELETE.html
Make sure you have a backup if you think you may need the data in the
future.
-Tom
-Original Message-
From: Michael
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