SELECT * FROM table WHERE column IS NOT NULL

[suttercain]

Hi everyone,

 

I am running the following MySQL query:

<?php
$sql = mysql_query("SELECT * FROM comics WHERE story_arc IS NOT NULL") or die (mysql_error());
while($row = mysql_fetch_assoc($sql)) {
echo $row['title'];
}
?>

 

The problem is that it is outputting all 4000+ records, when it should only be about 100. Is there an error with my 'IS NOT NULL'?

 

Thanks.

[corbin]

Depending on how your inserting the data, it could be textual "null"....

 

Also, if you're using null in your insert it could be just inserting empty space ("").

 

You could try WHERE story_arc != '' AND story_arc != 'null' AND story_arc IS NOT NULL.