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