$rawData = Yii::app()->db->createCommand() ->select() ->from('company') ->where(array('like','name',':name'), array(':name'=>'%'.$keyWord.'%')) ->query();
here is what I want to do in SQL query: SELECT * FROM company WHERE name LIKE …(the key word that user input)
Please pardon me if my question is too easy for you. I just couldn’t make it work, and I’ve read Query Builder Tutorials several times.
Many thanks from a beginner! [/size][/font]