public static function getDisorderOptions($term) { return Yii::app()->db->createCommand()->select('term')->from('disorder')->where('term LIKE :term and active = 1', array(':term' => "%{$term}%"))->queryColumn(); }