[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