asmith Posted January 1, 2008 Share Posted January 1, 2008 select * from table where (location1='abcd' or location2='abcd') and userid>56 and userid<72 and username !='none' i have one line with exactly that option . but that sql line won't find anything , when i remove the "and username !='none'" , it works fine . i want to tell sql select with that option where user isn't "none" . so i really need that line . how can i fix it ? ( the default field for username is NULL. so this field can be NULL, "none" , and variation of words . ) i want it to detect NULL too , only none is not allowed how can i acheive this ? Link to comment https://forums.phpfreaks.com/topic/83954-null-problem/ Share on other sites More sharing options...
asmith Posted January 1, 2008 Author Share Posted January 1, 2008 hmm i guess i can do it with : select * from table where (location1='abcd' or location2='abcd') and userid>56 and userid<72 and username !='none' or username is null works fine ! but seems a little wierd for me lol Link to comment https://forums.phpfreaks.com/topic/83954-null-problem/#findComment-427235 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.