Jim R Posted September 14, 2011 Share Posted September 14, 2011 I'm using Sequel Pro on Mac. My query is: SELECT * FROM fallLeague10 WHERE confirm!='y' I have three values: y m NULL I'm trying to get the rows that aren't y. Only the rows of m show up. I can't get the NULL rows to show up. Link to comment https://forums.phpfreaks.com/topic/247135-having-problem-with-a-query-i-think-should-be-easy/ Share on other sites More sharing options...
fenway Posted September 14, 2011 Share Posted September 14, 2011 Yeah, you have to do weird stuff with NULLs -- easier to use use "WHERE confirm <> 'y' or confirm is NULL". Link to comment https://forums.phpfreaks.com/topic/247135-having-problem-with-a-query-i-think-should-be-easy/#findComment-1269269 Share on other sites More sharing options...
Jim R Posted September 14, 2011 Author Share Posted September 14, 2011 It appears I had the wrong syntax. Thanks. That worked. Link to comment https://forums.phpfreaks.com/topic/247135-having-problem-with-a-query-i-think-should-be-easy/#findComment-1269272 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.