[Dbix-class] Newbie from SQL to DBIx

[Andreas Dafferner]

I'm quite new to DBIx and cannot find out what is the DBIx way for

select distinct left (col, (length(col) - 9)) from table order by col

???

Thank you for any help

Andreas