Jump to content

NULL problem?


asmith

Recommended Posts

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.