I've written a query to check for users with certain criteria, one being they have an email address.
Our site will allow a user to have or not have an email address.
WHERE `indvSettingID`=5 AND `optionID`='.$time.')
Is this the best way to check for an empty field in SQL? I've just tried "IS NOT NULL" and this still returned a user's record without them having an email address.
The query above works but out of curiosity, I wondered if I'm doing it the correct way.