On Thu, Mar 29, 2007 at 11:23:32AM +0200, Matija Grabnar wrote:
> I want to select only those rows where the two columns are unequal.
>
> select * from sometable where sometable.a != sometable.b;
>
> Any ideas?
I've ended up using scalar-refs to do this - I haven't found any other
way:
->search(
{
a => \'!= b',
}
)
Chisel
--
Chisel Wright
e: [EMAIL PROTECTED]
w: http://www.herlpacker.co.uk/
Atheism is a religion, provided you also accept that
NOT collecting stamps is a hobby.
_______________________________________________
List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class
Wiki: http://dbix-class.shadowcatsystems.co.uk/
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/
Searchable Archive: http://www.mail-archive.com/[email protected]/
