How to properly bindParam() in Yii1?

Question

Yii

There are JSON format records in the table, you need to find data in these records by condition.
I did Yii::app()->db->createCommand(), then select, from and add a condition:
andWhere('myTable.json LIKE \'%"phone":"' . $this->getPhone() . '"%\'');
This option works, but I need to do it with bindParam(),
andWhere('myTable.json LIKE \'%"phone"\:":searchPhone"%\'',[
':searchPhone' => $this-> getPhone()
]);
I get the error invailid parameter number: number of bound variables does not mathc number of tokens
What could be the problem?

Answer 1

andWhere(['like', 'json', '%'. $this->getPhone() .'%'])