I am trying to get a result from the database using yii framework.
I have written a query which is working fine. But the requirement is I should get only not null values.
Like select * from emp where managerid != ‘’ .
so I want to apply the not null condition in sql query.If any body has already done on this, please reply me.
and my query is $get_words = Yii::app()->db->createCommand()
->select('*') ->from('vocab') ->where('sourcelanguage=:sourcelanguage', array(':sourcelanguage'=>$srcId)) ->Where(array('IN','word_meaning_id',$word_stack)) ->queryAll();
and i want to add not null constraint as well to this query.