How do I build a LIKE query with DbCommand/Query Builder?
Just before posting the question, I had the good mind to read the Yii CDbCommand docs again, and I figured this out myself:

$query-&gt;orWhere(array(
    'like',
    'somecolumn',
    '%foo%'
));