LiveCode Forums.

Posted: **Tue Jun 03, 2014 4:39 pm**

"SELECT * FROM yard WHERE loc <>'Used'"

This will give me everything where loc is something other than Used, but it will not give any records where loc is NULL, what would you recommend?

Posted: **Tue Jun 03, 2014 5:12 pm**

Code: Select all

SELECT * FROM yard WHERE loc <>'Used or loc IS NULL

No ?

Posted: **Tue Jun 03, 2014 6:40 pm**

works great, thank you so much.

LiveCode Forums.

MySQL Query not returning NULL

MySQL Query not returning NULL

Re: MySQL Query not returning NULL

Re: MySQL Query not returning NULL