Selecting only table columns that aren't empty..

[Scooby08]

I have been searching around and found that to select all columns from the database table that aren't empty I would need to use a query like so:

 

SELECT * FROM table WHERE column IS NOT NULL

 

It's not working out for me.. Shouldn't that do the trick?

 

 

[Adam]

That would depend entirely upon your table structure.

[Scooby08]

Will this help?

 

CREATE TABLE `table` (
  `id` int(30) unsigned NOT NULL auto_increment,
  `column` varchar(10) NOT NULL default '',
  PRIMARY KEY  (`id`)
)

 

This also seems to work:

 

SELECT * FROM table WHERE column != ''

 

Do you see any problems with that?

 

[Adam]

That's because NULL != an empty string. In your database structure you have `column` set up as "NOT NULL", which means it cannot take NULL values. So in essence everything in that column will be NOT NULL.