[SOLVED] Order By Issue

[scott_dev]

I have query
select * from xyz where xyz.a=0
ORDER BY FIELD(xyz.a,'1','2','3','4','5') ASC

How can we convert this query in Symfony 1.0


$oCriteria->addAscendingOrderByColumn("field(xyz.a, '1','2','3','4','5')");

[a.ankitpatel]

$oCriteria->addAscendingOrderByColumn("field(tablename.fieldname, 'a','b','c','d','e','f')");

[sujit]

$oCriteria->addAscendingOrderByColumn("field(xyz.a, '1','2','3','4','5','6')" ;