Jump to content

Selecting only table columns that aren't empty..


Scooby08

Recommended Posts

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?

 

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.