Minor syntax changes.
I don't know Yii well enough, but I would suggest adding two additional examples: IS NOT NULL and LIKE 'foo%'