http://qs321.pair.com?node_id=374644


in reply to Class::DBI specifying field is NULL

This should do the trick:

my @listings = Table::Listings->search(somefield => undef);