Yii2 add LIKE condition with "%" wildcard on the one side

Question

I want to add like condition with % wildcard on the one side, like:

where name like 'value%'

My code:

Table::find()->filterWhere(['like', 'name' , $_GET['q'].'%' ])
        ->all();

But query result is:

 where name like '%value\%%'

score 53 · Accepted Answer · edited Apr 19 '22 at 07:52

53

You need set the fourth operand to false in order to use custom where like conditions:

Table::find()->where(['like', 'name', $_GET['q'] . '%', false]);

From the docs:

Sometimes, you may want to add the percentage characters to the matching value by yourself, you may supply a third operand false to do so. For example, ['like', 'name', '%tester', false] will generate name LIKE '%tester'.

edited Apr 19 '22 at 07:52

Stijn de Witt

40,192
13
79
80

answered Sep 03 '16 at 08:08

nadar

1,008
11
15

why i bind $_GET['q'] in param isn't the where automatic escape it's parameters ? and if i want to add it in the params how to do this ? – Hossam Aldeen Ahmed Sep 03 '16 at 08:37
Yes, the operator format will auto escape the input. – nadar Sep 03 '16 at 08:44

score 5 · Answer 2 · edited Jul 16 '20 at 08:51

5

You can use:

Table::find()->where(new \yii\db\Expression('name LIKE :term', [':term' => $_GET['q'] . '%']));

or

Table::find()->where(['like', 'name', $_GET['q'] . '%', false]);

or

$likeCondition = new \yii\db\conditions\LikeCondition('name', 'LIKE', $_GET['q'] . '%');
$likeCondition->setEscapingReplacements(false);
Table::find()->where($likeCondition);

More info at https://www.yiiframework.com/doc/api/2.0/yii-db-conditions-likecondition

edited Jul 16 '20 at 08:51

Juan Antonio

2,451
3
24
34

answered Sep 26 '19 at 09:45

killlinuxkill

337
3
8

Yes. Fixed. Thanks. – killlinuxkill Sep 26 '19 at 11:57

Yii2 add LIKE condition with "%" wildcard on the one side

2 Answers2