note 22144 deleted from function.is-null by danbrown

Note Submitter: dstone[at]NOSPAMviatraining.com ---- The above example is a little wrong. An empty value is not equivalent to null in mysql. To get not null in mysql use "... where column is not null" If you are doing a left join in mysql, no matched entry returns a null, where if you had a matched entry and were asking about a text field, '' might match, so != '' is different than is not null