how to test for null

[guyfromfl]

im working on my band's website, and some shows we have a flyer some we dont

 

i want to cycle the shows we do have flyers/pictures for randomly.

 

 

this is the SQL im using right now but wont work.

 

SELECT showId, showPicture
FROM shows
WHERE showDate >= curdate()
AND showPicture IS NOT NULL
ORDER BY rand()

 

where by default showPicture is set as null (so i could use that test to see if there was a flyer associated with that show)

 

when i type that query directly into my MySQL cmd line it returns all the results that are comming up (by date) with and with out pictures...

 

all i need are the ones that are comming up AND have a picture to display.

 

 

[Barand]

SQL looks OK so maybe they are just '' (empty string) if no flyer, and not NULL.