[Dbix-class] order by field?

[Octavian Rasnita]

Hi,

In MySQL is possible to do something like:

select * from table_name order by field(department, 'Marketing', 'Sales', 'Financial', 'IT', 'Operations');

In other databases it should be done differently....

Is it possible to do this search with DBIC?

--Octavian