MySQL Query not returning NULL

Got a LiveCode personal license? Are you a beginner, hobbyist or educator that's new to LiveCode? This forum is the place to go for help getting started. Welcome!

Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller

Post Reply
DavJans
Posts: 275
Joined: Thu Dec 12, 2013 4:21 pm

MySQL Query not returning NULL

Post by DavJans » 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?
"Det bästa stället att hitta en hjälpande hand är i slutet av din egen arm" förutom här

bangkok
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 937
Joined: Fri Aug 15, 2008 7:15 am

Re: MySQL Query not returning NULL

Post by bangkok » Tue Jun 03, 2014 5:12 pm

Code: Select all

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

DavJans
Posts: 275
Joined: Thu Dec 12, 2013 4:21 pm

Re: MySQL Query not returning NULL

Post by DavJans » Tue Jun 03, 2014 6:40 pm

works great, thank you so much.
"Det bästa stället att hitta en hjälpande hand är i slutet av din egen arm" förutom här

Post Reply