Andfilterwhere And Case-Insensivity

Yii 2.0 General Discussions
1

I’m using mongodb for ActiveRecord.

in my search model I had




    $query->andFilterWhere(['like', 'name', '/'.$this->name.'/i']);

and it was works fine.it’s broken now.

if I change it to




    $query->andFilterWhere(['like', 'name', $this->name]);

works fine but it’s case-sensitive.

2

Solved!




    $query->andFilterWhere(['REGEX', 'name', '/'.$this->name.'/i']);