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? Quote 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--] Quote 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. Quote Link to comment https://forums.phpfreaks.com/topic/12109-ignoring-empty-entries/#findComment-46109 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.