[Dbix-class] How do I use the value of a field in a where clause

[Moritz Onken]

Hi,

is it possible to do such a query?
SELECT * from table where field1 = MD5(field2)

field2 is not a string but a field in the table.

Thanks

Moritz Onken