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 }});

[tags]dbix::class null sql perl[/tags]

|  Print This Post