[font="Georgia"][size="3"]
$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]