willdikuloz Posted June 15, 2006 Share Posted June 15, 2006 Is there a way to SELECT only entries that actually have something in them and ignore the empty ones? Link to comment https://forums.phpfreaks.com/topic/12109-ignoring-empty-entries/ Share on other sites More sharing options...
Barand Posted June 15, 2006 Share Posted June 15, 2006 [!--sql--][div class=\'sqltop\']SQL[/div][div class=\'sqlmain\'][!--sql1--][span style=\'color:blue;font-weight:bold\']SELECT[/span] colname [color=green]FROM[/color] [color=orange]tablename[/color] [color=green]WHERE[/color] colname IS NOT NULL [!--sql2--][/div][!--sql3--] Link to comment https://forums.phpfreaks.com/topic/12109-ignoring-empty-entries/#findComment-46095 Share on other sites More sharing options...
willdikuloz Posted June 15, 2006 Author Share Posted June 15, 2006 Doesn't work, I heard that empty values is different from null. Link to comment https://forums.phpfreaks.com/topic/12109-ignoring-empty-entries/#findComment-46109 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.