What wrong with my query building function with operator "LIKE"?

Yii 1.1 General Discussion
1

[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]

2

Is binding parameters in LIKE condition possible in Query Builder?

3

I got it,




            	$rawData = Yii::app()->db->createCommand(array(

                	'select' => array('*'),

                	'from'=> 'company',

                	'where'=>array('like','name','%'.$keyWord.'%'),

                	

                	

            	))->query();

Thanks every one!