suttercain Posted May 14, 2007 Share Posted May 14, 2007 Hi guys, I have this right now: SELECT title, COUNT(*) as numissues FROM comics WHERE type ='Comic Book' GROUP BY title" But I need something like: SELECT title, COUNT(*) as numissues FROM comics WHERE type ='Comic Book OR IS NULL' GROUP BY title" The second line doesn't work. How would I get it to select where IS NULL and also Comic Book? Thanks guys! SC Link to comment https://forums.phpfreaks.com/topic/51379-an-or-in-the-mysql-where-syntax/ Share on other sites More sharing options...
veridicus Posted May 14, 2007 Share Posted May 14, 2007 SELECT title, COUNT(*) as numissues FROM comics WHERE type ='Comic Book' OR type IS NULL GROUP BY title Link to comment https://forums.phpfreaks.com/topic/51379-an-or-in-the-mysql-where-syntax/#findComment-252999 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.