yii2 new Expression

yii2 new \yii\db\Expression,yii2 FIND_IN_SET

演示一段 yii2 关于 new Expression 或者 new \yii\db\Expression 的 sql 语句

首先

use yii\db\Expression;

$params = ['1','2'];


$query = Model::find();

$where = ['or'];
$query->where('1=1');
foreach($params as $v){
    $where[] = new Expression('FIND_IN_SET(:field, field)',[':field'=>$v]);
}
$query->andWhere($where)->asArray();

echo $query->createCommand()->getRawSql();

输出 sql 语句：

SELECT * from `table` where 1=1 AND ((FIND_IN_SET('2', field)) OR (FIND_IN_SET('2', field)));

修改：

//切记 字符串中包含变量用双引号""，不然变量不会解析。
$i = 0;
foreach($params as $v){
    $where[] = new Expression("FIND_IN_SET(:field_$i, field)",[":field_$i"=>$v]);
}

//切记字符串中包含变量用双引号""，不然变量不会解析。

再次输出 sql 语句：

SELECT * from `table` where 1=1 AND ((FIND_IN_SET('1', field)) OR (FIND_IN_SET('2', field)));