help to create Yii Criteria

I am newbie to Yii,

can someone pl. help me to write a critearia for this sql.

select centerID, cast(centerID as UNSIGNED) as disCode, tblDistrict.disName from tblRainfallData,tblDistrict where disCode=tblDistrict.discode;

I tried a few ways but no success.


I guess the problem is "cast(centerID as UNSIGNED) as disCode"? If so, try using