I needed to write a query using DBIx::Class tonight that would return rows where a column wasn’t null. The first couple of ways I tried to didn’t work - here’s how to do it:

$result = $schema->resultset('RESULTSET')->search({ column => { '!=' => undef }});

(more…)