Search operator for field = undefined

[Robin H]

I feel dumb asking this but I really can't find the answer eleswhere.
Does anyone know how to construct a phpmyadmin search to return only
those records where a particular field is undefined? The field in
question is a varchar type. Thanks

[David Hadley]

Hi Robin,

Do you mean something like this (or am I being too simplistic?) The "IS
NOT NULL" part takes out any entries that are NULL for that field
(assuming NULLs are allowed -- but I don't want to get into a debate
about the similarities/differences between undefined and NULL!)

SELECT * FROM sometable WHERE fieldname <> "" AND fieldname IS NOT NULL;

Cheers,
Dave