CanMan2004 Posted February 12, 2007 Share Posted February 12, 2007 Hi all Im trying to do a simple query to pick up all rows which have no value in one of there fields. The problem is that all rows which have NULL as a defult value, are not treated as empty. How can I make the query read NULL as an empty field? Thanks Ed Link to comment https://forums.phpfreaks.com/topic/38171-query-on-null/ Share on other sites More sharing options...
paul2463 Posted February 12, 2007 Share Posted February 12, 2007 can you not make the query pick up both cases anyway $query = "SELECT idrow FROM table WHERE column = '' OR column IS NULL" Link to comment https://forums.phpfreaks.com/topic/38171-query-on-null/#findComment-182707 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.