[Dbix-class] Comparing two columns in a table

Matija Grabnar matija at serverflow.com
Thu Mar 29 10:23:32 GMT 2007


Say that I have a table which contains, among other stuff, two columns
(call them a and b):

I want to select only those rows where the two columns are unequal.

select * from sometable where sometable.a != sometable.b;

I've looked through Dbix::Class::Resultset and Cookbook, as well as 
SQL::Abstract man page, and couldn't find anything that showed
how to compare two columns in the same table, only how to use a function 
on a column.

Any ideas?



More information about the Dbix-class mailing list