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 Quote 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 Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.