I've been digging for some months now (off and on) for the means by which to query for fields with a value of NULL, but haven't turned anything up yet. Till now, I've managed to improvise some other way round this, but enough already!
Please, what would be the syntax?
Iv'e tried ....
SELECT from campaign_log
WHERE target_id = NULL
SELECT from campaign_log
WHERE target_id = 'NULL'
SELECT from campaign_log
WHERE target_id = ''
SELECT from campaign_log
WHERE target_id NOT LIKE '%-%'
(as there happen to be dashes in all target_id's)
BUT NONE OF THESE RETURN ANY RESULTS.
